Cells with GetPivotData Function show Blank

[JD Ami]

Developed a simple application in Excel 2002 on my XP Pro w/s.

Using GetPivotData to calculate the % each row total is of the grand
total.

Distributed application to other w/s in group running various other
versions of Windows and Excel.

Works as expected on all but one workstation.

That w/s is running Win2K and Excel2K.

In that one instance, calc cells appear blank... although the calc
formula is still visable in the edit window when a calc cell containing
the GetPivotData calc is selected.

All our other Win2K machines running Excel2K behave as expected and the
% values show in the calc cells.

???

Thanks!

John Davis.

 

[Debra Dalgleish]

In Excel 2000, GETPIVOTDATA uses different arguments. You could have a
row with the 2002 formula, e.g.:


=IF(INFO("release")="10.0",GETPIVOTDATA("Units",$A$3,"Region","Ontario","Item","Pencils"),"")

and in the row below, the 2000 formula, e.g.:

=IF(INFO("release")="9.0",GETPIVOTDATA($A$3,"Ontario Pencils Sum of
Units"),"")