I have a pivot table that contains three columns of data: FY 2008, FY 2009 and Grand Total. I would like to display the difference between FY 2008 and FY...

I have a pivot table sourced from Analysis Services with a drill down. When I use the drill down, the detail report pops up in a new tab as desired. ...

Hi everyone. I have a series of data (3 columns and several rows). Here you have the example: date & time |value1|value2| 2006-07-11 00:00:00 | -203...

Right now I have =DATE(YEAR(V4),MONTH(V4)-1,DAY(V4)) Works great however if I don't have a date in V4 then it comes back NUM. How can I get rid of that. Can...

I have a spreadsheet that requires a user to input a hex value. but the hex values don't always display and there is no fault checking. (2 issues) Simple...

How do I eliminate obsolete values in my pivot table filters? I reset my data range, refreshed my table and even created a new pivot table but the values I...

Details: I have over 100 identical worksheets with the same combo box user control scrollbar on each Excel worksheet to allow user to choose from one of 6...

Hi there! I have an access 97 macro that outputs to excel and is defaulting to the earliest version in the list, excel 3. I can't seem to find anywhere the...

I have Vista and just installed Office Pro 2007. I get this code when I open Excel. How can I fix this? I have already uninstalled and reinstalled.

I have been trying to figure out how to loop when using a copy formulas and then find specific words and paste ( I am also using an offset to paste below the...

I have a pivot table the # of calls, and type that a person received. I'd like to show the total number and % in columns next to each other. What I have...

I have a spreadsheet with a worksheet with several thousand physician names, addresses, etc. In another worksheet in the same file I have a list of about 200...

Openned a file provided by an outsider, Saved, and now all files I open have numbers on the column headers, the rows are still numbered. but it's not...

What are the shortcut keys to "Open Hyperlink" in Excel 2007?

Is it possible to customize Excel so that the name of the spreadsheet always prints on a hard copy?

Sorry, began posting earlier and hit send by mistake! I have a spreadhsheet that I enter orders onto with the requested delivery date and order volume. e.g...

I want to know if a part number is NOT listed in the array of future demand.

I know that converting text to columns is simple but i'm wondering if I can create a macro to conver text to rows? Would the easist way to do this be simply...

Is it possible to protect a worksheet but still allow people to insert comments to cells. Even if the cell is unprotected, Excel still doesn't allow...

Hi, I have a spreadsheet which lists Sales and dates that those orders are to be delivered on. These dates do not run consecutively on the spreadsheet...