Pivot table refresh

[matts12]

Ok, so I have 4 data tables on separate sheets and I have their respective pivot tables on separate sheets also. Now I am using macros to switch to the sheets that contain the pivot tables. And within these macros I have a line of code that refreshes the pivot tables when switching to them which makes sense. However I am experiencing some bad lag when doing so and am wondering if there is a line of code that I could use that would ONLY update the pivot table if there is a change in data in the data table. It's annoying when a user is just looking at reports and has to wait every time for the pivot table sheets to refresh. And overall it makes my workbook look bad. Any help would be appreciated. Thanks.

 

[James006]

Hi,
You have not posted your code ...

Do not use RefreshAll ...
but

Sheet1.PivotTables("PivotTable1").Refreshtable

 

[matts12]

Ok I have RefreshAll at the moment, do you think that's where the lag comes from? BTW I'm new on here, I am still figuring out how to post the code the way everyone else does it

 

[James006]

A couple of remarks ...

1. Remove RefreshAll and test the suggested instruction ...

2. In the tiny above your answer, you should see a choice of icons such as XLS and VBA ... the VBA one does insert the code tags you need

 

[matts12]

I get subscript out of range error

sheets("Grain Sales Reports").PivotTables("Grain Sales Reports").RefreshTable