Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 GETPIVOTDATA
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 GETPIVOTDATA
I deleted and then recreated the pivot table and this seemed to help.
Everything is working well now. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GETPIVOTDATA on Excel 2000 | Excel Worksheet Functions | |||
GETPIVOTDATA Excel 2000 | Excel Worksheet Functions | |||
GETPIVOTDATA....Excel 2000....Desperation! | Excel Worksheet Functions | |||
getpivotdata function with Excel 2000 | Excel Discussion (Misc queries) | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions |