A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Follow these steps in order, testing saving in Excel after each step.
- Confirm the file location and permissions
- If saving to a network drive, external drive, OneDrive, or SharePoint, try saving to the local Mac disk instead (for example, Desktop or Documents).
- Ensure full permissions (Read, Write, Modify, Delete) on the folder where the file is being saved. If saving to a shared/network location, ask the administrator to grant Modify and Delete rights. Without these, Excel’s save process cannot complete.
- If saving to a network location and changes disappear or temporary files with random names appear, this indicates missing Modify/Delete rights on that folder.
- Try saving with a new name and/or different format
- In Excel, select File > Save As and:
- Save with a completely new file name.
- Save to a different folder on the local disk.
- Optionally change the file type (for example, from
.xlsto.xlsxor.xlsm).
- Check for path and naming issues
- Ensure the full path (folders + file name) is not excessively long. Very long paths can cause save failures.
- Avoid special characters in the file name and keep the name relatively short.
- Test for add‑in or background process interference
- Close Excel.
- Start Excel in Safe Mode (on Windows this is done with Ctrl at startup; on Mac, the equivalent is to start Excel with all add‑ins disabled and no startup files).
- Create a new workbook and try to save it locally.
- If saving works in this clean state, disable or remove third‑party add‑ins or startup files that may be interfering with the save process.
- Check antivirus or other security software
- If any antivirus or security software is installed, it may be locking Excel’s temporary files during save.
- Temporarily disable it and test saving locally. If saving works, configure the software to exclude Office temp files or update it per the vendor’s guidance.
- Verify OneDrive / Files On‑Demand or cloud sync
- If saving directly into a OneDrive‑synced folder, ensure OneDrive is signed in and fully synced.
- If Files On‑Demand or similar features are enabled, update Office to the latest version and test again.
- If saving still fails, save to a purely local folder, then manually upload the file to OneDrive or SharePoint via the browser.
- Last‑resort workarounds to get the tax file out If the problem persists but the workbook is open and editable:
- Use File > Save As to a different local folder with a new name and different file type.
- If that still fails, copy all worksheets into a new workbook:
- Insert a temporary blank sheet.
- Group all real sheets, move them to a new workbook, and save that new workbook locally.
- Once saved locally, attach or upload that file as required for the county.
If none of these steps allow saving any Excel files locally, collect the exact error messages shown when saving fails and contact Microsoft Support with those details.
References:
- Troubleshoot why Excel doesn't save changes
- You may receive a "Your changes could not be saved" error message when you try to save a file to a network drive in Excel
- Office files may not save if Files On-Demand is enabled
- Excel or PowerPoint error: "This file cannot be saved because some properties are missing or invalid"