Fix Excel Cannot Save Workbook or Sharing Violation Error
Question details
The user needs to resolve Excel's failure to save a workbook, which reports a sharing violation, missing temporary file, or repair prompt.

- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- A user tries to save an Excel workbook, but Excel blocks the save with a sharing violation or related error.
- Observed behavior
- Excel reports a sharing violation, missing temporary file, or repair prompt and does not save the workbook.
Before changing settings, copy the current data to a new blank workbook or Excel for the Web so your edits are preserved. Then note the exact save location and simplify the file name if it contains symbols such as slashes or periods.
Save a Copy to a Trusted Local Folder with a Simple File Name
Use this first when Excel reports a sharing violation or cannot save, because save location and file name issues are the most common causes.
This resolves the most common causes: restricted locations, invalid file names, and temporary lock files.
In Excel, click File > Save As and choose a local location such as Desktop or Documents.
Enter a new file name with only letters, numbers, spaces, hyphens, or underscores. Remove special characters such as slashes, periods, commas, or #.
Click Save and check the selected folder to confirm the workbook copy was created without the sharing violation.

Update Excel and Test with a Blank Workbook
Use this if the first copy still fails, to determine whether the issue is workbook-specific or caused by an outdated Excel installation.
Test Excel in macOS Safe Mode and Repair Office on Mac
Use this on macOS when local copy and update checks do not resolve the save failure.
Open and Save the Excel Workbook in WPS Spreadsheets
If Microsoft Excel still blocks the save, open the file in WPS Spreadsheets, edit or verify the content, and save it as an Excel-compatible workbook from a clean local location.
- 1. Open WPS Spreadsheets: Launch WPS Office and open WPS Spreadsheets from the home screen.
- 2. Open the problematic workbook: Click File > Open and browse to the Excel workbook that currently fails to save in Microsoft Excel.
- 3. Save a new local copy: Select File > Save As, choose Desktop or Documents, enter a simple file name, and choose Excel Workbook (.xlsx) as the format.
- 4. Verify the saved copy: Close and reopen the new file in WPS Spreadsheets to confirm the data and formatting are intact.

Frequently Asked Questions
Why does Excel say "sharing violation" when saving a workbook?
This normally means the file is open in another app, located in a restricted folder, or has a temporary lock. Save a copy to the Desktop or Documents folder with a simple file name first.
Can WPS Spreadsheets open and save an Excel file that Microsoft Excel cannot save?
Yes, you can open the workbook in WPS Spreadsheets and use File > Save As to create a new .xlsx copy. This often bypasses the Excel lock or sharing violation.
Should I remove periods and slashes from the Excel file name?
Yes for troubleshooting. Use only letters, numbers, spaces, hyphens, and underscores, and avoid special characters in both the file name and folder path.
How do I check for Excel updates on Mac?
Open Excel, select Help > Check for Updates or use Microsoft AutoUpdate, install any pending updates, and then retry saving the workbook.
What should I do if a blank Excel workbook also cannot save?
The issue is likely the save location, folder permissions, or Office installation. Review the folder permissions and repair or update Office, then test again.




