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

"Mac" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

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


"Bernard Liengme" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>
>

[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" <[email protected]> napisał w
wiadomości news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>
>

[Max]

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" <[email protected]> wrote in message
news:[email protected]...
> 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]

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" <[email protected]> wrote in message
> news:[email protected]...
>
>>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