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

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mac" wrote in message
...
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

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 :-)
------------------------------*------------------------------*----------------


"Bernard Liengme" wrote in message
...
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mac" wrote in message
...
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

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

U¿ytkownik "Bernard Liengme" napisa³ w
wiadomo¶ci ...
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mac" wrote in message
...
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

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mac" wrote in message
...
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

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.

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

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mac" wrote in message
...

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





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html