Forum Discussion
Solved
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...
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
If you cannot attach a workbook, please upload it to a cloud service such as Google Drive or OneDrive, obtain a link and post the link in a reply.
Thank you for letting me know.
Please find the link. Hope you can open the file
https://www.dropbox.com/scl/fi/6zom3bfr87hg5emtttui3/Draft.xlsx.xlsm?rlkey=gyo60h0f0m9r4tesjqm7mhedz&dl=0
Thanks