How to Fix Excel for Mac Not Saving Worksheet Changes
Question details
Users are experiencing an issue where edits made to an Excel workbook are lost after the file is closed and reopened.

- 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 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.
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.
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.
Click on 'File' in the top Apple menu bar and select 'Save As' from the dropdown menu.
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'.

Install Office and macOS Updates
Resolve underlying compatibility bugs by ensuring both your operating system and Microsoft Excel are running the latest versions.
Recover Changes Using Version History
If you have already closed the file and lost your work, check OneDrive's version history to restore a previously synced state.
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. Download and Install: Visit the official WPS website, download the free version for macOS, and complete the installation.
- 2. Open Your Workbooks: Launch WPS Spreadsheet and easily open your existing .xlsx or .xls files without losing any formatting.
- 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.

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.




