PivotCache.Refresh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help with this error please, when I run the following statement in
my macro

ActiveSheet.PivotTables("DataPivot").PivotCache.Refresh


Runtime error 1004

Unable to get the PivotTable properties of the worksheet task
 
Are you sure that's the name of the pivot table on the active sheet?
 
Can anyone help with this error please, when I run the following statement in
my macro

ActiveSheet.PivotTables("DataPivot").PivotCache.Refresh

Runtime error 1004

Unable to get the PivotTable properties of the worksheet task
Click to expand...

If there's one PivotTable on the sheet you can also use:
ActiveSheet.PivotTables(1).PivotCache.Refresh

If you want to verify the name you can use:
Debug.Print ActiveSheet.PivotTables(1).Name
 
I was getting the same message. I even tried recording a macro to refresh the
pivot table, but got the same code. It seemed to have worked in Excel 2003
but not in 2007.

I don't have much VBA experience, but when I changed the statement to be,
ActiveSheet.PivotTables("DataPivot").RefreshTable, the macro would continue
to run.

Hope this helps.

Kara
 
You must log in or register to reply here.

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

Excel 2007 Run-Time error 1
Run-Time error '1004: Unable to get the PivotTables property of the worksheet class 4
Pivot Table Refreshes Via Code 2
ChangePivotCache 0
Refresh data with macro code 0
Using macro to switch 'page' in a pivot table? 1
Hide actions while macro executes 1
Excel VSTO pivot table code revision help needed... 3

Back
Top