GETPIVOT DATA HELP - PLEASE!!!!

M

Matt

I have coded cells with the following:

=IF((OR(D10=0,X10=1)),0,GETPIVOTDATA("Responders",'Response Pivot
Table'!$C7,"M Code",Report!A10))

This was done in Excel 2003...when a client tried to open in 2000, they get
a #VALUE! error....what is going wrong?!!!! That would be pretty goofy in my
opinion if you can't keep worksheet functions the same between versions....

I need help ASAP! Thanks!!!
 
R

Ron Coderre

If a function isn't available in Excel, the error value would be #NAME!.

The #VALUE! error probably indicates a problem with the data.
Can you give more information?

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
D

Debra Dalgleish

The GetPivotData arguments are different in Excel 2000.

If you create the formulas in the earlier version, Excel 2003 should be
able to calculate them. However, Excel 2000 can't calculate the newer
version's format.
 
Top