I have XL97 running on Windows 2000. If I have a spreadsheet with a
chart on its own tab, and I switch from a "data" tab to the chart, I get
run time error 438 Object doesn't support this property or method.

Going into Debug, I find it has stopped he

Sub UpdateIt()
Dim iP As Integer
Application.DisplayAlerts = False
For iP = 1 To ActiveSheet.PivotTables.Count <<<<---------
ActiveSheet.PivotTables(iP).RefreshTable
Next
Application.DisplayAlerts = True
End Sub



I didn't write this, so I assume it's part of Excel VB. Has this sub got
changed by mistake? I don't know of anywhere I can check it out.

Any help would be appreciated.