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
each time i change the Master Table, I need to manually right click and refresh the Pivot table so that the corresponding tables have accurate data
How do i have a Refresh Button added that i can Anyone in the team to click if they change the Master table? or Auto Refresh Pivot table when Master table data is changed?
View best response
@ratishkp You can assign this to a shape or button:
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!