Problem with ThisWorkbook.RefreshAll

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

Guest

I have a ton of tabs and each has a pivottable on it. I've tried to use the
VBA code ThisWorkbook.RefreshAll but everytime I run it nothing happens, the
pvt table does not refresh. Does anyone have any possible reason as to why
this might be?

Thanks Vick
 
Where is the source data for the pivot table? Has new data been added,
or records changed?
 
The source data of the document is another document. Data has been added,
but the existing records have not changed.
 
Perhaps the pivot table's source range doesn't include the rows with the
new records.
Right-click on the pivot table, and click on PivotTable Wizard.
Click Back, and see if all the rows are included.
 
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

ThisWorkbook.RefreshAll Issue/Question 1
Pivot Table Link Error 2
Excel Pivot Table Refresh Question 2
Sheet Deactivate problem 1
VBA Code 2
Excel Pivot tables refresh 3
Deactivate event not firing 1
Macro won't select columns 1

Back
Top