refresh pivot tables through a macro
 

Hi all,

I'm trying to create a macro to update pivot tables with a macro. but
when I create it and then try to run it, I receive the message: It'
impossible to find the propriety Pivot tables for the class Worksheet.
the Macro is:
"Sheets("Inserimento Dati").select
Range("H24").Select
ActiveSheet.PivotTables("tabella_pivot1").RefreshT able"

The system is Excel 2003 in XP. I did a similar macro in WIN 98 and it
worked, but it used a PivotTables wizard that does not work any more
in XP.

Thanks a lot in advance, hope I've been clear enough.

Where do you have your code?

maybe:
Sheets("Inserimento Dati").PivotTables("tabella_pivot1").RefreshTable

or if you think the name of the PT changed:

Dim PT As PivotTable
For Each PT In Worksheets("Inserimento Dati")
PT.RefreshTable
Next PT



dolph wrote:

Hi all,

I'm trying to create a macro to update pivot tables with a macro. but
when I create it and then try to run it, I receive the message: It'
impossible to find the propriety Pivot tables for the class Worksheet.
the Macro is:
"Sheets("Inserimento Dati").select
Range("H24").Select
ActiveSheet.PivotTables("tabella_pivot1").RefreshT able"

The system is Excel 2003 in XP. I did a similar macro in WIN 98 and it
worked, but it used a PivotTables wizard that does not work any more
in XP.

Thanks a lot in advance, hope I've been clear enough.

--

Dave Peterson