Fix Excel Keeps Asking to Save Changes After Saving
Question details
The user is experiencing an issue where Excel continuously prompts them to save changes upon closing a workbook, even immediately after manually saving the file.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Closing an Excel workbook after making and saving edits.
- Observed behavior
- Excel incorrectly detects new changes and displays a prompt asking to save the file again before exiting.
Ensure you have manually saved a backup copy of your workbook to a local drive, and check if AutoSave is toggled on, as syncing delays to the cloud might trigger false prompts.
Check for and Remove Volatile Formulas
Volatile formulas recalculate every time the workbook is opened or interacted with, causing Excel to think unsaved changes exist.
Functions like TODAY(), NOW(), INDIRECT(), and RAND() are volatile. They update their values constantly. Even if you just open the file and close it without touching anything, Excel registers the updated formula as a new change and asks you to save.
Open your affected workbook and press Ctrl+F to open the Find dialog. Search for terms like TODAY(), NOW(), or RAND().
If real-time updating is not required, copy the cells containing these formulas, right-click, and select 'Paste Special' > 'Values' to convert them into static text or numbers.
Save the workbook using Ctrl+S and try closing it again to see if the prompt is resolved.

Open Excel in Safe Mode to Disable Add-ins
Third-party add-ins or background macros might be making invisible changes to your file right before you close it.
Check File Sharing and AutoRecover Settings
Multiple open files or network sharing conflicts can sometimes confuse Excel's save state.
Try WPS Office for a Smoother Spreadsheet Experience
If Microsoft Excel continues to have saving conflicts, add-in glitches, or annoying prompts, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly spreadsheet tool that handles complex data without the common frustrating quirks.
- 1. Download WPS Office: Visit the official WPS website to download and install the free suite.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing Excel files directly—no data or formatting will be lost.
- 3. Save Without Hassle: Edit and save your work securely with reliable local and cloud syncing.

Frequently Asked Questions
What is a volatile formula in Excel?
A volatile formula, such as =TODAY(), =NOW(), or =RAND(), recalculates its value every time any change is made to the worksheet or when the file is opened. This constant background recalculation makes Excel think the file has been modified, triggering the save prompt.
Can Excel macros cause the save prompt to appear?
Yes. If a macro is set to run in the background (like a Workbook_Open or Worksheet_Calculate event), it can alter data or formatting without your direct input. Excel registers these automated background changes and will ask you to save them upon closing.
Why does this happen only with specific workbooks?
This issue is usually file-specific because it depends heavily on the contents of the workbook. Only files containing volatile functions, active macros, external data connections, or corrupted sharing permissions will repeatedly trigger the prompt after saving.
Does clearing the Excel cache help fix this saving issue?
Sometimes. If temporary files are corrupted, clearing your Office document cache can resolve syncing errors, particularly for files stored on OneDrive or SharePoint that are struggling to properly register the 'saved' status.




