Excel VBA Pivot Table problem

[Meshuga]

I have a spreadsheet with a pivot table that pulls ending case reserves from a named range. I have VBA code that will refresh all my pivot tables when I update my data range. When my code hits the following line:

ActiveSheet.PivotTables("OS").RefreshData

I get the following error:

Object doesn't support this property or method.

I am on the correct sheet. This code worked in Excel 97 before we upgraded and I recorded the refresh to see if it should be coded differently, but Excel generated the same code.

Any ideas on why I'm receiving this error?

thanks

[NoName]

try RefreshTable

[Meshuga]

thanks. i should try reading the generated code a little closer.