getpivotdata

[Mac]

Hi
I have workook with getpivotdata function. In excel 2003 it work propoerly,
but in excel 2000 it does not work, there is another version of this
function. Anybody knows how resolve this problem? I do not want to install
excel 2003, but I think I schould copy function library (dll file). I do not
know which file includes GetPivotData function, anybody konows?
Is it possible?
thx
Mac

 

[Bernard Liengme]

This is part of a pivot table. You cannot just type =GETPIVOTDATA(
You may need to refresh the pivot table when you open file in another
version of Excel.
best wishes

 

[Ken Wright]

Or even turn it on if the feature has been turned off. Add the pivot table
Toolbar and look for the GETPIVOTDATA icon.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Mac]

I do it, but the problem is: in excel 2000 GETPIVOTDATA has only 2
arguments, in excel 2003 there is another version of this function (16
args). I think I need replace library (dll) with this funcction, but ido not
konow what file...
thx
Mac

 

[Max]

Not sure whether it might help here, but try Debra's page at:
http://www.contextures.com/xlPivot06.html

 

[Debra Dalgleish]

If you create the GetPivotData in Excel 2000, it should return a valid
result in Excel 2003. However, Excel 2000 will return an error for a
GetPivotData formula created in Excel 2003.