Forum Discussion
Chris525
Apr 01, 2024Copper Contributor
Auto Refresh for Pivot tables created on sheets (Master data also on the same sheet)
Hi Kindly suggest me a way to refresh the pivot tables created in excel automatically Sheet 1 - Main Data (We update daily) Sheet 2 - Pivot tables How can I refresh the pivot tables on s...
- Apr 01, 2024
Click in a pivot table.
Activate the PivotTable Analyze tab of the ribbon.
Click 'Change Data Source'.
Either type the name of the table, or click in the box, then activate the sheet with the source table, and select the entire table. Excel should automatically replace the range address with the name of the table.
Click OK.
See for example 5 Reasons to Use an Excel Table as the Source of a Pivot Table
Chris525
Apr 01, 2024Copper Contributor
HansVogelaar
Apr 01, 2024MVP
I converted the source range to a table, and set the pivot tables to refer to the table instead of to a fixed range,
- Chris525Apr 02, 2024Copper Contributor
- HansVogelaarApr 02, 2024MVP
I'm not an expert on SharePoint, I cannot help you with that. Sorry!
- Chris525Apr 02, 2024Copper Contributor
Another question, the file was already uploaded and shared on SharePoint with others. How can I make the changes (Those pivot tables) and save as macro file?
Please advice.
Thanks
- Chris525Apr 02, 2024Copper Contributor
- HansVogelaarApr 01, 2024MVP
Click in a pivot table.
Activate the PivotTable Analyze tab of the ribbon.
Click 'Change Data Source'.
Either type the name of the table, or click in the box, then activate the sheet with the source table, and select the entire table. Excel should automatically replace the range address with the name of the table.
Click OK.
See for example 5 Reasons to Use an Excel Table as the Source of a Pivot Table
- Chris525Apr 01, 2024Copper Contributor
Thank you!!
Sorry one more question how did you set the pivot tables to refer to the table instead of to a fixed range?
Can you kindly suggest me any tutorials I can refer regarding this subject?
Thanks