refresh pivot table data automatically

  • Thread starter Thread starter Richardjs60
  • Start date Start date
R

Richardjs60

Hi
can anybody please tell me if it is possible to have a pivot table
refresh automatically in excell 2000
in table options I can click refresh on open BUT the sheet is generally
open all the time the next box Refresh every ? is not active
Any help appreciated
regards

Richard Sutton
 
The Refresh every x minutes options is available for pivot tables that
use an external data source.

You could use the Worksheet_Activate event to refresh the pivot table
when its worksheet is activated. For example:
'============================
Private Sub Worksheet_Activate()
ActiveSheet.PivotTables(1).PivotCache.Refresh
End Sub
'==========================

The above code is stored on the sheet's module (right-click the sheet
tab, choose View Code, then paste the code onto the module)
 
Back
Top