Forum Discussion
Solved
Set Auto Refresh to Pivot Table as Source Data Changes
Overview: 1. Have a Master table where Cost per Month Per Item is added. 2. Using this Master table, have created a Pivot tables where i create new views about the data like Cost per Category ...
ratishkp You can assign this to a shape or button:
Sub foo()
ActiveWorkbook.RefreshAll
End Sub
Or if the PivotTable is on another sheet, you can add ActiveWorbook.RefreshAll to the Worksheet_Activate event, and it will automatically update whenever the sheet is selected.
ratishkp You can assign this to a shape or button:
Sub foo()
ActiveWorkbook.RefreshAll
End Sub
Or if the PivotTable is on another sheet, you can add ActiveWorbook.RefreshAll to the Worksheet_Activate event, and it will automatically update whenever the sheet is selected.
Thank you Smitty Smith ! that worked!
