Automatic refresh of the pivot table data

  • Thread starter Thread starter steveski
  • Start date Start date
S

steveski

I have a data entry sheet and a pivot table based on the data entry
sheet. Is there a way to make the pivot table data refresh
automatically based on some trigger (e.g., leaving the data entry
sheet)?
 
I have a data entry sheet, two pivot tables based on the data entry
sheet, and two charts (not pivot charts) based on the pivot tables. One
chart is located in a sheet, the other is a stand-alone chart. When I
turn the file over to the user, the pivot tables will be hidden. I want
both charts to automatically refresh when I click their tabs. For the
chart located in the sheet, I have used the following code, which works
great:

Private Sub Worksheet_Activate()
ActiveWorkbook.RefreshAll
End Sub

However, this code does not work if I use it with the stand-alone
chart. Do I need to change something to make it work in the chart?

Thanks.
 
Back
Top