Office for Mac Issues

How to Fix Excel for Mac Not Saving Worksheet Changes

John WilsonJohn Wilson Oct 29, 2026 870 views

Question details

Users are experiencing an issue where edits made to an Excel workbook are lost after the file is closed and reopened.

How to Fix Excel for Mac Not Saving Worksheet Changes
Product
Microsoft Excel
Device & OS
macOS (Big Sur 11.6) and iOS
Scenario
Editing and saving spreadsheets in the Microsoft 365 desktop or mobile app.
Observed behavior
Worksheet changes disappear entirely after closing and reopening the workbook, failing to save locally or sync properly.
Before you start

Before attempting any fixes, manually copy your current unsaved data and paste it into a new, temporary text file or a blank workbook to prevent permanent data loss during troubleshooting.

Solution 1Recommended

Save the Workbook Locally Under a New Name

Use this solution to bypass potential OneDrive synchronization delays or file path corruption that prevents Excel from saving your work.

Network interruptions or cloud storage sync glitches can sometimes prevent Excel from committing changes to the original file. Saving a fresh copy to your local Mac storage forces the application to create a new, uncorrupted file instance.

1
Check AutoSave Status

Look at the top-left corner of the Excel window to see if the 'AutoSave' toggle is turned on. If it is disabled, your changes are not being synced to the cloud.

2
Initiate Save As

Click on 'File' in the top Apple menu bar and select 'Save As' from the dropdown menu.

3
Select Local Storage

Click the 'On My Mac' button if prompted, choose a local directory such as your Desktop or Documents folder, give the file a new name, and click 'Save'.

Save the Workbook Locally Under a New Name
Verification Step: Close the newly saved local file and reopen it to verify that your most recent changes have been successfully retained.
Free Microsoft Office alternative

Experience Stable Spreadsheet Saving with WPS Office for Mac

If Microsoft Excel on macOS or iOS repeatedly fails to save your worksheet changes, WPS Office provides a highly stable, lightweight, and entirely free alternative. It ensures your spreadsheets are saved securely without sync issues, allowing for seamless migration and robust format compatibility.

  1. 1. Download and Install: Visit the official WPS website, download the free version for macOS, and complete the installation.
  2. 2. Open Your Workbooks: Launch WPS Spreadsheet and easily open your existing .xlsx or .xls files without losing any formatting.
  3. 3. Edit and Save Safely: Edit your data and use Cmd + S to save your progress reliably to your local drive or integrated cloud storage.
100% compatible with Microsoft Excel (.xlsx, .xls, .csv) file formatsReliable local saving and built-in Auto Backup to prevent data lossLightweight app design with fast loading speeds optimized for macOSFamiliar user interface for a seamless transition from Microsoft Office
microsoft office alternative - wps office

Frequently Asked Questions

Why is AutoSave disabled on Excel for Mac?

The AutoSave toggle in Excel is only available when your workbook is actively saved and synced to a Microsoft cloud service like OneDrive or SharePoint. If you saved the file locally on your Mac or to a third-party service like iCloud or Google Drive, AutoSave will remain disabled.

Where does Excel for Mac store AutoRecovery files?

Excel for Mac stores AutoRecovery files in a hidden system folder. You can find them by opening Finder, pressing Cmd+Shift+G, and pasting this path: ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/.

Can upgrading to a new macOS cause files not to save?

Yes, major operating system upgrades can sometimes cause permission errors or compatibility issues with older Office versions. Updating Microsoft Office immediately after a macOS upgrade usually resolves these saving conflicts.