'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel 2021 Cannot Save Workbook and Saving Errors
Question details
The user is unable to save their spreadsheet because Excel 2021 repeatedly displays an 'Errors were detected while saving' prompt.
- Product
- Microsoft Excel 2021
- Device & OS
- not provided
- Scenario
- Attempting to save changes to an existing workbook or trying to save a newly created file in Excel 2021.
- Observed behavior
- Excel displays a recurring error message stating 'Errors were detected while saving' and loops the message when attempting the suggested corrections, ultimately preventing the file from being saved.
Before making system changes, verify if the saving error occurs in just one specific workbook or all Excel files by creating and saving a brand-new blank spreadsheet.
Troubleshoot a File-Specific Saving Error
Use this method if the saving error only affects one particular workbook while others save normally.
File-specific saving errors are often caused by unsupported content, corrupted formatting, or conflicting add-ins within that specific spreadsheet.
Click 'File' > 'Save As', choose a completely different local folder (like your Desktop), and save the file with a new name.
Delete any recently inserted complex charts, heavily formatted shapes, or external linked images that might be triggering the corruption loop.
Go to 'File' > 'Options' > 'Add-ins'. Manage 'COM Add-ins', click 'Go', uncheck all active add-ins, and try saving the workbook again.
Perform an Online Repair of Microsoft Office
If Excel fails to save any workbook (both new and old), repairing the Office installation can fix corrupted core application files.
Reset Excel Registry Keys
As a last resort for system-wide saving failures, reset the Excel registry configurations to clear out corrupted background settings.
Use WPS Office to Save and Edit Your Spreadsheets Without Errors
If Microsoft Excel 2021 consistently fails to save your workbooks due to registry issues or software corruption, consider switching to WPS Office. It is a free, lightweight alternative that is fully compatible with Microsoft Excel formats, ensuring your data is always saved securely without complex troubleshooting.
- 1. Download and Install: Get WPS Office for free from the official website and complete the quick installation.
- 2. Open your problematic file: Right-click the Excel workbook that wouldn't save, select 'Open with', and choose WPS Office.
- 3. Save your work securely: Make your edits and simply press Ctrl+S. WPS Office will save the file natively in the standard .xlsx format without throwing errors.
Frequently Asked Questions
Why does Excel say 'Errors were detected while saving'?
This generic error usually occurs due to conflicting COM add-ins, corrupted workbook objects (like complex shapes or charts), network drive permission issues, or antivirus software interfering with the temporary file creation process during saving.
How do I open Excel in Safe Mode to test saving?
Press and hold the 'Ctrl' key on your keyboard while clicking the Excel shortcut to open it. A prompt will ask if you want to start in Safe Mode. Click 'Yes'. If the file saves successfully in Safe Mode, a third-party add-in is likely causing the error.
Where is the Excel XLSTART folder located?
The XLSTART folder stores templates and macros that load automatically. It is typically located at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART. Moving files out of this folder temporarily can resolve startup and saving conflicts.
Will repairing Office online delete my Excel files?
No. Running an Online Repair from the Control Panel only reinstalls and fixes the core application files of Microsoft Office. Your personal workbooks, spreadsheets, and data will remain completely untouched.
