This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 60%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
I renewed my subscription to Microsoft 365 on or about 4 December 2025 but Excel does not have the facility to auto refresh a pivot table.
From research I understand that this facility was built into 365 between July & November, so why doesn't the software that I have paid for and downloaded include the auto refresh facility?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Is this where you're looking:
If it isn't there...Please go to Excel> About Microsoft Excel in the Excel menu bar to determine the present Version Number & type of License. Include that information in your reply here.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 39%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
I am having this same issue, except mine is not even there!
This thread is nearly one year old. It Much has changed since this was active.
It would be to your advantage to submit a New Question rather than burying it in a old Mac thread. State all current version information as well as any pertinent details. Use the Ask a Question button in the upper right corner of this page.
Also, it appears you're using a Windows version. If so be sure to select the correct platform when you create the question.
I have just seen the attached - the auto refresh is 'greyed out' so how can I get that to be a selection?
Unfortunately I'm not sure what else to suggest other than pointing you to this Microsoft blog post:
Keep data updated with PivotTable Auto Refresh in Excel
Perhaps something there will be useful, especially in the Tips & Tricks section.