Excel 2002 vs. Excel 2000

[steveski]

I (with your help!) developed an Excel Worksheet using PivotTables
PivotChart, and VBA using Excel 2002 (10.2614.2625). I tried to run i
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 Dat
2",PV1Started!R3C1,"Priority","E","Start Date 2",12,"Years",2003)),0
GETPIVOTDATA("Start Date 2",PV1Started!R3C1,"Priority","E","Start Dat
2",12,"Years",2003))”

Do you know why this formula does not work under Excel 2000?

Thanks

 

[Debra Dalgleish]

The GETPIVOTDATA arguments are different in Excel 2000. Check in Excel's
Help for examples. In your code, you can test for the version, and
insert the appropriate formula, e.g.:

Select Case Application.Version
Case "10.0" 'Excel 2002
'formula for Excel 2002
Case "9.0" 'Excel 2000
'formula for Excel 2000
Case Else
MsgBox "Wrong version"
Exit Sub
End Select

 

[steveski]

I cannot get the GETPIVOTDATA command to work under Excel '97. Help

 

[Debra Dalgleish]

GetPivotData should be the same in Excel 97 as it is in Excel 2000.
What problem are you having?