ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel 2003 issue (https://www.excelbanter.com/excel-discussion-misc-queries/43659-excel-2003-issue.html)

yazh

excel 2003 issue
 
Hi,
In Excel 2003 iam trying to get the data out through the Pivot
facility. After that i do arithmethic works using the pivoted cells.
during that time in the formula bar it tell me something like
"GETPIVOTDATA".

Now the issue is if i open the same file in office 2000 then pivot
table is seen but the arithmetic programmed fields show as "#VALUE".

Please help me to get the data back at my arithmetic fields.

regards
Yazh


Paul

The Getpivotdata function is an amazing function but it does not exist in
Excel 2000. It has caused me many many many headaches!!!!

"yazh" wrote:

Hi,
In Excel 2003 iam trying to get the data out through the Pivot
facility. After that i do arithmethic works using the pivoted cells.
during that time in the formula bar it tell me something like
"GETPIVOTDATA".

Now the issue is if i open the same file in office 2000 then pivot
table is seen but the arithmetic programmed fields show as "#VALUE".

Please help me to get the data back at my arithmetic fields.

regards
Yazh




All times are GMT +1. The time now is 04:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com