Excel 2000 GETPIVOTDATA

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

Guest

I have a pivot table with dates as columns (11/1/2005, 2/1/2005,
3/1/2005...), three fields as rows and three data fields, including
"ORDERS_DOLLARS". When I use the GETPIVOTDATA in Excel 2000 to return the
sums for each month, some months work and others return "#N/A."

Here is a formula that works:
=GETPIVOTDATA(Sheet1!$A$5, "ORDERS_DOLLARS 11/1/2005")

Here is a formula that returns "#N/A"
=GETPIVOTDATA(Sheet1!$A$5, "ORDERS_DOLLARS 7/1/2005")

I can see that the pivot table has data for 7/1/2005 and 11/1/2005.

Does anyone have any ideas on why both formulas are not working?

Thanks.
 
I deleted and then recreated the pivot table and this seemed to help.
Everything is working well now.
 
Back
Top