I (with your help!) developed an Excel Worksheet using PivotTables, PivotChart, and VBA using Excel 2002 (10.2614.2625). I tried to run it under Excel 2000 (9.0.3821 SR-1), and the Pivot Tables, Pivot Charts, and VBA worked, but the following formula did not work:
“=IF(ISERROR(GETPIVOTDATA("Start Date 2",PV1Started!R3C1,"Priority","E","Start Date 2",12,"Years",2003)),0, GETPIVOTDATA("Start Date 2",PV1Started!R3C1,"Priority","E","Start Date 2",12,"Years",2003))”
Do you know why this formula does not work under Excel 2000?
Thanks.
“=IF(ISERROR(GETPIVOTDATA("Start Date 2",PV1Started!R3C1,"Priority","E","Start Date 2",12,"Years",2003)),0, GETPIVOTDATA("Start Date 2",PV1Started!R3C1,"Priority","E","Start Date 2",12,"Years",2003))”
Do you know why this formula does not work under Excel 2000?
Thanks.