Excel 2000 GETPIVOTDATA

[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.

 

[Guest]

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