Excel 2002 vs. Excel 2000

  • Thread starter Thread starter steveski
  • Start date Start date
S

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
 
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
 
GetPivotData should be the same in Excel 97 as it is in Excel 2000.
What problem are you having?
 
Back
Top