Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |