#Value! Errors from a GETPIVOTDATA function

[Philip J Smith]

Hi I have a report which picks up data from a pivot table using the
GETPIVOTDATA function.

e.g. =GETPIVOTDATA("Total",Electricity!$A$3,"Planning
Group",$A5,"Sub-Transaction",D$2,"Summary","Energy Price")

It works well in Excel 2003. However when I send the file to a colleague
who uses Excel 2000 all the results are replaced by "#Value!"

He has the analysis toolpack installed, Any ideas what the problem might be?

 

[Philip J Smith]

I think I've worked out what the problem is.

To save on file size I unchecked the “Save data with table layout†box in
Pivot Table options.

This seems to have caused Excel 2000 to interpret the pivot table as an
ordinary table hence returning the #Value! error.

I rechecked the box and resent the file and it worked properly.

 

[Debra Dalgleish]

The arguments for the GETPIVOTDATA argument are different in Excel 2000,
so if your colleague refreshes the pivot table the #VALUE! errors will
appear.