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