'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Missing Automatic PivotTable Refresh in Excel
Question details
The user is unable to find the automatic PivotTable refresh feature in Excel after renewing their Microsoft 365 subscription.
- Product
- Microsoft Excel
- Device & OS
- macOS / Windows
- Scenario
- Attempting to enable automatic data refresh for a PivotTable connected to an internal workbook table.
- Observed behavior
- The automatic refresh option is not visible in the PivotTable settings because the feature is still rolling out to specific update channels and builds.
Verify that your Excel calculation options are set to Automatic rather than Manual, and ensure your spreadsheet is saved in the .xlsx format.
Enable 'Refresh data when opening the file' Workaround
Since the automatic refresh feature is rolling out gradually, setting your PivotTable to refresh every time the workbook opens is the best immediate alternative.
Microsoft is slowly rolling out the automatic PivotTable refresh feature to Insider and Beta channels first. Standard users may not see this feature immediately, even after renewing a Microsoft 365 subscription.
Until the update reaches your device, you can use the built-in option to refresh data automatically whenever the file is opened.
Click anywhere inside your existing PivotTable to reveal the PivotTable Analyze and Design tabs on the ribbon.
Right-click the selected cell within the PivotTable and choose 'PivotTable Options' from the context menu.
Navigate to the 'Data' tab in the PivotTable Options dialog box and check the box next to 'Refresh data when opening the file', then click OK.
Check Your Office Update Channel
The automatic refresh feature depends on your specific Microsoft 365 update channel and build version, not your subscription renewal date.
Manage Data and PivotTables Effortlessly with WPS Office
Tired of waiting for feature rollouts or dealing with confusing update channels? WPS Office provides a comprehensive, easy-to-use spreadsheet application with powerful PivotTable capabilities, completely free of charge.
- 1. Open your file in WPS Spreadsheets: Launch WPS Office and open your existing .xlsx workbook.
- 2. Access PivotTable Tools: Click anywhere inside your PivotTable to bring up the specialized PivotTable tools.
- 3. Refresh Data Instantly: Click the 'Refresh' button on the ribbon to instantly update your PivotTable with the latest data from your source table.
Frequently Asked Questions
Does renewing Microsoft 365 give me access to Beta features?
No, renewing your subscription simply extends your active license. It does not change your assigned Office update channel. You will remain on your standard track (e.g., Current Channel) unless you manually opt into the Microsoft 365 Insider program.
Why is the automatic PivotTable refresh missing on my Mac?
The feature is rolling out incrementally. If your macOS Excel version is earlier than build 16.99 or if you are not enrolled in the Insider Beta channel, the automatic refresh option will remain hidden until it is officially released to the public.
Can I automatically refresh my PivotTable without using macros?
If you don't have the new automatic refresh feature, the best non-macro workaround is to format your source data as a Table and check 'Refresh data when opening the file' under PivotTable Options > Data.
Why won't my PivotTable update manually when I click refresh?
This usually happens if your Excel Calculation Options are set to 'Manual' instead of 'Automatic', or if your PivotTable source range does not include the newly added rows. Converting your source data to an official Excel Table fixes the range issue.
