excel auto refresh

Richard 0

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?

Bob Jones AKA CyberTaz MVP 437.8K Reputation points

2025-12-18T16:15:19.8133333+00:00

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.
Jason Teran 0 Reputation points

2026-09-22T22:25:17.4866667+00:00

I am having this same issue, except mine is not even there!
Bob Jones AKA CyberTaz MVP 437.8K Reputation points

2026-09-23T15:51:10.2666667+00:00

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.

7 answers

Bob Jones AKA CyberTaz MVP 437.8K Reputation points

2025-12-18T17:42:49.34+00:00

Version 16.104 is the correct & latest release which is what my screenshot depicts.. Are you shown as the Belongs to: in the About... dialog or is some business or organization indicated? (Don't disclose that information, though.)

When did you last restart the Mac? Some new features don't appear after provided by an update until the Mac is restarted. Unfortunately there is no notification to that effect.

Also, be sure the window is wide enough to fully display the Data group on the PivotTable Analysis tab.

Note that unless the file is saved in a current file type [e.g., .xlsx] the tools still should be there but is not active.
Was this answer helpful?

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Richard 0 Reputation points

2025-12-18T16:49:20.34+00:00

Thanks. Yes it is what I am looking for and established that the version I have is 16.104 (25121423) which does not seem to be the right version. After I sent thru my original message, I ensured that all updates have been installed. The licence is shown as .... Licence: Microsoft 365 Subscription
Was this answer helpful?
Richard 0 Reputation points

2025-12-18T17:11:01.4466667+00:00

Just to confirm I am using a MacBook Pro
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

excel auto refresh

7 answers

Your answer