Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to convert GETPIVOTDATA from excel 2000 to excel 2002...
I have a excel file which was created in excel 2000 and is using getpivotdata
function. The function returns #REF when the file is opened in excel 2002 or excel 2003. Is that anyway that I can convert function Getpivotdata from excel 2000 to excel 2002 so that the file can be opened in excel 2002? |
#2
|
|||
|
|||
I don't know of any way to convert the formula. However, it's easier to
create a GETPIVOTDATA formula in Excel 2002 or Excel 2003. Turn on the Generate GetPivotData feature (there are instructions he http://www.contextures.com/xlPivot06.html Then, click on the cell that you want to reference, and the formula will be automatically created. Need_help_on_excel wrote: I have a excel file which was created in excel 2000 and is using getpivotdata function. The function returns #REF when the file is opened in excel 2002 or excel 2003. Is that anyway that I can convert function Getpivotdata from excel 2000 to excel 2002 so that the file can be opened in excel 2002? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in Excel 2000 how do I convert text to numbers? | Excel Discussion (Misc queries) | |||
Excel 2000 Program not launching | Excel Discussion (Misc queries) | |||
Excel 2000 to Excel 2003.... is it worh it? | Excel Discussion (Misc queries) | |||
How to send Excel 2000 worksheets to Excel 2003? | Excel Discussion (Misc queries) | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) |