#Value! Errors from a GETPIVOTDATA function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
The arguments for the GETPIVOTDATA argument are different in Excel 2000,
so if your colleague refreshes the pivot table the #VALUE! errors will
appear.
 
Back
Top