Auto Refresh Pivot Tables

[sdsilva]

Hi,

I have several pivot tables in a workbook on separate worksheets. Rather than pasting the auto refresh pivot table code for each worksheet that has a pivot table, I would like a single code within the workbook that would refresh the pivot table everytime the worksheet is activated.

I am curently using this code for every worksheet with a pivot table-
Private Sub Worksheet_Activate()
'If this worksheet is activated, refresh the pivot table
Sheets("Pivot").PivotTables("PivotTable").RefreshTable
End Sub

Can you please help. Thanks,
Sabrina

 

[Atroxell]

NM Sorry. Foggy-brained Friday morning...I replied by giving exactly what you say you do not want...

 

[sdsilva]

As an update, I do not want to have the pivot tables refreshed everytime the worksheet is activated, but everytime there is a change to the data file.

If the worksheet is refreshed everytime activated, it refreshes even if there are no changes and takes a while to update as the file is very large.

Thank you for your help.

Regards,
Sabrina