NEW Excel Feature: Auto Refreshing Pivot Tables

Excel has just introduced a great feature for pivot table users—Auto Refreshing Pivot Tables.
No more right-clicking to refresh your data manually! In this walkthrough, we explore how this new functionality works, how to enable it, and what limitations still exist. You’ll see live examples of changes in the dataset immediately reflected in pivot tables, including auto-updates when new rows are added.

Version:
Currently this is all part of a "flighting" beta release, meaning only some beta users will see it for now.

You’ll also learn how to access the auto-refresh toggle through PivotTable Analyze, set it globally through Excel’s default layout, and how pivot caches affect this feature.


🫶🏻 Join the channel to get access to perks:
   / @accessanalytic  

🧑🏻‍🎓Learning Power BI?
Check out our online course
https://accessanalytic.thinkific.com/

📗 Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/

The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/



00:00 How to Enable and Disable Auto Refresh Pivot Tables via PivotTable Analyze
01:14 Setting Auto Refresh via PivotTable Options
01:40 Set Auto Refresh as a Workbook Default
02:28 Understanding Pivot Caches and Multiple Data Sources
03:38 Turning Auto Refresh On/Off Per Pivot Table
04:00 Final Thoughts & Beta Availability