refresh pivot tables through a macro

D

dolph

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").RefreshTable"

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.
 
D

Dave Peterson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making a Pivot Table from data of a Close sheet visa Button(Macro) 0
Pivot Table Macro 1
How to create a pivot table in a new worksheet by recording a macro 1
VBA Pivot Table Error 1
Retain pivot table formatting after refreshing data 0
Pivot Table - Old remaining values for rows 3
Playing back a Pivot Table macros 2
Pivot Tables - refresh from Userform command button 2

Top