File Corruption & Recovery

Fix "Errors Detected While Saving" in Excel 365 on Windows 11

Maira Mehtab Oct 10, 2026 869 views

Question details

The user needs to fix an error where Excel 365 fails to save and removes macros when using the "Save As" function to create audit versions.

How to Fix "Errors Detected While Saving" in Excel 365 on Windows 11

Product: Microsoft Excel 365
Device & OS: Windows 11
Scenario: Using the "Save As" feature to create numbered audit versions of macro-enabled workbooks.
Observed behavior: Excel displays an "Errors were detected while saving" prompt and subsequently strips macros from the saved workbook.

Before you start

Before troubleshooting, open the affected workbook and manually copy your VBA code from the Developer tab into a separate text file (like Notepad) to prevent permanent macro loss if Excel forces a file repair during the next save attempt.

Solution 1Recommended

Verify System Date Formatting and File Location

Incorrect regional date settings or restricted file paths in Windows 11 often trigger save errors and file corruption warnings in Excel 365.

Excel relies on Windows regional settings for certain file operations. If the system date format contains characters that conflict with file saving protocols, or if the save directory lacks proper permissions, Excel may fail to save the macro-enabled workbook.

Check Windows Date Format

Open the Windows 11 Control Panel, navigate to 'Clock and Region', and click 'Region'. Ensure the Short Date format is set to a standard layout (e.g., MM/dd/yyyy) without unusual special characters.

Change Save Location

Instead of saving to a network drive or a cloud-synced folder (like OneDrive), use 'Save As' and select a local directory such as your Desktop or Documents folder to rule out sync conflicts.

Verify File Extension

When using 'Save As' to create your numbered audit version, double-check that the 'Save as type' dropdown is explicitly set to 'Excel Macro-Enabled Workbook (*.xlsm)'.

Verify System Date Formatting and File Location

Test on Another Device: If the error persists after checking settings, try opening and saving the workbook on a different computer to determine if the issue is specific to your device or the file itself.

Solution 2

Run an Online Repair for Microsoft Office

Repairing the Microsoft 365 installation can resolve underlying software corruption that causes persistent saving errors.

Free Microsoft Office alternative

Try WPS Office for Reliable Spreadsheet Management

If Excel 365 continues to experience saving errors or macro corruption, consider switching to WPS Office. It provides a lightweight, free, and highly compatible environment for your spreadsheets, ensuring your work is saved safely without frustrating interruptions.

1. Download and Install: Visit the official WPS website to download the free installation package and follow the on-screen prompts to install.
2. Open Your Workbooks: Launch WPS Spreadsheets and directly open your existing Excel workbooks without needing file conversions.
3. Save Safely: Edit your files and utilize the 'Save As' feature securely with full support for standard spreadsheet formats.

Completely free and lightweight office suiteExcellent compatibility with Microsoft Excel formats (.xlsx, .xlsm, .csv)Familiar tabbed interface for a seamless migrationStable and reliable saving mechanism for complex workbooks

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel remove macros when showing the 'Errors detected while saving' prompt?

When Excel encounters a critical error during saving, it attempts to repair the document to salvage the data. This automated repair process often strips out complex elements it suspects are corrupted, which frequently includes VBA modules and macros.

Can I recover macros lost during an Excel save error?

If you have not closed the original file where the error occurred, you can press Alt + F11 to open the VBA editor and export your modules. If the file was already closed and saved over, you must restore the macros from a previous backup.

Why does 'Save As' trigger this error more often than a regular 'Save'?

The 'Save As' function creates a completely new file instance and registers it with the operating system. This process is more susceptible to conflicts with antivirus software scanning, cloud synchronization tools, or invalid characters in the new file name.

Document & File Issues