Is there any way to have getpivotdata retrieve more than one set of data, other than doing it like below? =GETPIVOTDATA('Roll-up Pivot'!$F$2,"hours enrg E...

Anybody know where I can find a definitive list of changes to Excel 2000, XP and 2003. Is there a better resource? I have tried this, but I'm looking for...

I have some Excel files in which "Format Cells" is not working. I cannot bring up the format cell box either through Ctrl-1, the task bar, or right-clicking...

Using XL 2003 Apparently, I am too close to the problem to figure out an error in the following routine. Sub DeleteBlankRows() is to delete all Rows which...

Is there any way to protect or lock a "freeze window" setting so that others can't unfreeze the window, change the rows, and re-freeze the window, thereby...

I have an Excel2000 workbook on a shared drive; users fill out some cells in the excel file and are supposed to do a "save as" to save it as a separate file....

I have a filter set up. Every time I click one of the drop down lists to select a sub-set Excel saves my spreadsheet with the new selection set. What is going...

Hello! My problem is that Excel crashes when i open one of my files. I have experienced this only ones before in all of theese years I have been using...

This is an old post, but I wanted to post the solution for others to benefit from. I did a complete re-install of Windows XP and the whole problem was...

When I use ctrl/end in my worksheet, I end up in column HH:93 even though as far as I can see I only have data through I:93. How can I find the ghost data...

Hello, I have office XP. The issue that I am having is when I export a table from Access to Excel (and I'm usually copying over an old file because it's a...

Hi, I created a Macro but I want to have it show up on a toolbar. I know that you can create a custom toolbar but how can i add a macro (which I would need an...

Hi I get "Personal.xls locked for editing by '.' " for users opening Excel. Can anyone advise where this file is and who could have it locked ? thanks Wayne

Is there away to get sequential page numbers in each footer for each page if I print an entire workbook? Example: If Sheet One is 3 pages, Sheet Two would...

I am attempting to link a SECTION of a word document to an excel document via a hyperlink but 'couldn't do it. I tried setting up a bookmark for the sections...

I need to copy a lot of raw data from html format into excel. Most of the data consists of a min/max figure (eg. 31/45) Excel (2003) always converts this...

hi in an excel sheet when i try to sutofit columns E and F then through a macro it gives error and stops the macro in betweeen. so i tried to double click...

I have two columns in a spreadsheet that have the following formula =IF(j8="",0,G8), I need to add something to this column that will flag if collections drop...

Though data sets can be bigger than they were in the past, issues are still occurring with smaller data sets. Users find that the processing is a lot worse...

Bob Phillips wrote: *Here's a technique that I discovered a few weeks ago, and I am getting fond of. This code assumes the client name in column A of...