GETPIVOT DATA HELP - PLEASE!!!!
 

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!!!

GETPIVOT DATA HELP - PLEASE!!!!
 

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


"Matt" wrote:

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!!!

GETPIVOT DATA HELP - PLEASE!!!!
 

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.

Matt wrote:
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!!!




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html