How to Fix Errors were detected while saving Excel?
![](/images/site-logo.png)
How to Fix “Errors were detected while saving Excel” Error?
When trying to save the Excel file, you might face unexpected errors. The “Errors were detected while saving Excel” is one such error. It can also occur when using VBA in Excel. The complete error message appears as:
**“Errors were detected while saving [file name]. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.”
**
The error can occur if the features (Pivot tables, charts, macros) used in the Excel file get corrupted . However, there could be several other reasons behind the occurrence of the error. Let’s discuss them.
What Causes the “Errors were detected while saving Excel” Error?
There are various reasons why you encounter this error. Here are some of them:
- Incompatible pivot table in the Excel file
- Large or uncompressed images in the Excel file
- File-sharing properties are not allowing file saving
- Excel file is corrupted
- Large-sized Excel file
- File version incompatibility
- VBA code is corrupted
Ways to Fix the “Errors were detected while saving Excel” Error
You’re not able to save the Excel file if there is no storage space on your hard drive. So, first check if your hard drive has sufficient storage space to save the file. If this is not the case, then it might happen that your antivirus program is interrupting the saving process. To check this, temporarily disable your antivirus program and then try to save the file. If still your Excel is throwing the “Errors were detected while saving Excel” error, then follow the below given methods to fix the error:
Method 1: Open the Excel in Safe Mode and Disable the Add-ins
When you open Excel in safe mode, it opens without the third-party add-ins. This helps in finding out if any add-ins are causing the error.
Here’s how to open the Excel in safe mode:
Open the Run window by pressing Windows key + R.
Type excel /safe in the Run window.
?
Next, click on OK.
It will open Excel in safe mode.
Now, try to open and save the affected file.
If you are able to save the file without any issue, then this means that the error has occurred due to third-party add-ins or settings. You can try disabling the add-ins to fix the issue. To do this, follow these steps:
- First, open Excel.
- Then, go to the File tab and click Options.
- In Excel Options, click on the Add-ins
- Under the Manage section, select Excel Add-ins and then click on the Go
In the Add-ins dialog box, unselect the add-ins under the Add-ins available option and click OK.
Note: Disabling add-ins does not remove them from the system. To remove them permanently, you need to uninstall them.
Method 2: Check the Excel File Name
Some users have observed this error when saving the Excel file with an invalid name. You can check the file name and ensure that it should not contain more than 218 characters. If the name exceeds the required limit, then try shortening the file name or move the file to a folder with a short path name.
Method 3: Copy the Data from the Affected File to a New File
If you are not able to save the Excel document, then try copying the data from the affected file to a new Excel file. Then, save the new file with a different name. This helps in resolving the issue.
Method 4: Check and Provide File Permissions
You may experience the “Errors were detected while saving Excel” issue when you do not have desired permissions to modify the folder in which your Excel file is located. To modify the folder, you should have read, write, and create permissions. You can check and provide the desired permissions using the below steps:
- Navigate to the Windows Program Files and then find the desired folder (where the Excel file is saved).
- Right-click on the folder and then choose Properties.
- Select the Security tab and then click
- Click on Change Permissions in the Advanced Settings
- Click Administrators and then click Edit.
- Now set the Apply to drop-down button to This Folder, Subfolder, and Files.
- Click on the Full Control field and then click Apply > OK.
Method 5: Check Pivot Tables in Excel Sheet
You can review Pivot tables to see if they are causing the “Errors were detected while saving Excel” error. To do so, follow the below steps:
Click Power Pivot > Manage.
Check the tabs in the Power Pivot
Check if all the formulas used in the table are correct. Sometimes, even a small typo can create an issue in Excel.
Method 6: Repair Your Excel File
The “Errors were detected while saving Excel” issue can also occur if the Excel file is corrupted. In such a case, you can take the help of the built-in utility in Excel – Open and Repair to repair your Excel file. Here’s how to use the tool:
- In Excel, click the File tab and then click Open.
- Click Browse to select the desired file.
- The Open dialog box is displayed. Click on the corrupted file.
- Click on the arrow next to the Open button and then click Open and Repair.
- Click on the Repair
After repair, a message will appear (as shown in the below figure).
Click Close.
However, sometimes, the Open and Repair utility fails to fix the file if it is severely corrupted or large-sized. In such a case, you can take the help of a third-party Excel repair software, such as Stellar Repair for Excel. The tool performs a comprehensive scan of the corrupted Excel file to fix the issues and recover all the items from the file without changing the original formatting. It can recover pivot tables, charts, images, engineering formulas, etc. The tool is compatible with Windows 11/10/8.1/8/7. You can download the free trial version of the tool to evaluate its functionality.
Closure
Many Excel users reported facing the situation when they are saving the Excel file. You can check the file’s compatibility to fix the “Errors were detected while saving Excel” issue. If you are getting this error in a Macro-enabled file then you can try deleting the VBA project from a document to resolve the issue. However, deleting the entire VBA code cannot be a better solution as it can lead a data loss in the Project you are working on. In the above article, you have learned the reasons behind the issue and discovered how to fix the error. Follow the methods and if none of them works then try using Stellar Repair for Excel. It is an advanced tool that can quickly repair corruption in Excel worksheets at any level. It lets you restore the corrupted components from the corrupted file without removing the existing data.
Also read:
- How to Repair Corrupt Excel 2019 Files | Stellar
- How to Rescue Lost Photos from Nokia G42 5G?
- How to Honor X50 GT Get Deleted Phone Number Back with Ease and Safety
- How to recover deleted photos from Android Gallery after format on Xiaomi
- How to retrieve lost files from Honor ?
- How to remove Google FRP Lock on Moto G 5G (2023)
- How to recover deleted photos on Samsung Galaxy A25 5G
- How to Repair Corrupt Excel 2019 Workbook?
- 4 Ways to Transfer Music from Motorola Moto G23 to iPhone | Dr.fone
- How to Sign .odt file document with Digital Signature - (Tutorial)
- How To Erase Private Data From iPhone 15 | Dr.fone
- How to Rescue Lost Messages from Motorola G54 5G
- How to retrieve erased videos from Storm 5G
- How To Repair iPhone 6s iOS System? | Dr.fone
- How to Downgrade iPhone 6 Plus to the Previous iOS Version? | Dr.fone
- How to Repair a Damaged video file of Honor X50i+ using Video Repair Utility on Windows?
- How to Restore Deleted Nokia G42 5G Pictures An Easy Method Explained.
- How To Recover Whatsapp Chat History From iPhone | Stellar
- How to recover deleted photos after deleting from Recently Deleted on iPhone 11 | Stellar
- How To Repair iPhone X System? | Dr.fone
- How to Oppo Find X7 Ultra Get Deleted Pictures Back with Ease and Safety?
- How To Recover Data from iPhone XS? | Dr.fone
- How to Remove MDM from iPhone 12 without a computer?
- How to Fix iPhone 12 Pro Max Stuck at attempting data recovery Loop | Stellar
- How to Fix Videos Not Playing on Honor ?
- How to recover deleted pictures from Motorola Moto G73 5G.
- How to Restore Deleted Note 30 5G Photos An Easy Method Explained.
- How to recover deleted photos on Galaxy M14 4G
- How to Remove MDM from iPhone 14 Pro Max without a computer?
- How to Repair corrupt MP4 and MOV files of Oppo Reno 10 Pro 5G?
- How to Oppo Find X7 Get Deleted Pictures Back with Ease and Safety?
- How to retrieve erased call logs from Huawei Nova Y71?
- How to restore wiped call history on Redmi Note 12 Pro 5G?
- How To Restore Missing Pictures Files from Infinix Zero 30 5G.
- How to Honor 90 GT Get Deleted Pictures Back with Ease and Safety?
- How To Erase iPhone 14 Data Permanently | Dr.fone
- How To Repair iOS System of iPhone SE (2022)? | Dr.fone
- How to Recover iPhone SE (2020) Data From iOS iTunes? | Dr.fone
- 2 Ways to Transfer Text Messages from Nokia C210 to iPhone 15/14/13/12/11/X/8/ | Dr.fone
- How to recover deleted photos from Lava Blaze 2 5G.
- 2 Ways to Transfer Text Messages from Samsung Galaxy A05s to iPhone 15/14/13/12/11/X/8/ | Dr.fone
- How to Recover Deleted Videos from iPhone XR Without Backup? | Stellar
- How to Put iPhone 15 or iPad on Recovery mode? (Step by Step Tutorial) | Stellar
- How to Repair a Damaged video file of Xiaomi using Video Repair Utility on Windows?
- How To Repair iOS System Issues of iPhone SE (2022)? | Dr.fone
- How to play AVCHD MTS files on Motorola ?
- 4 Solutions to Fix Unfortunately Your App Has Stopped Error on Infinix Note 30 | Dr.fone
- How do you play HEVC/H.265 files on Galaxy XCover 7?
- In 2024, How to Unlock Samsung Galaxy S23 Tactical Edition PIN Code/Pattern Lock/Password
- Can I use iTools gpx file to catch the rare Pokemon On Oppo Reno 10 5G | Dr.fone
- In 2024, Locked Out of iPhone X? 5 Ways to get into a Locked iPhone X | Dr.fone
- The 10 Best Tools to Bypass iCloud Activation Lock On Apple iPhone 13 Pro You Should Try Out
- New Audio Fade Ins and Outs Made Easy 2 Final Cut Pro Techniques for 2024
- How to Unlock iPhone 12 mini Passcode Screen? | Dr.fone
- Progressive Solutions to Adding VHS Effects to Video with Ease
- How To Remove Flashlight From Apple iPhone 8 Lock Screen | Dr.fone
- Updated Things About Transparent PNG Remove and Convert for 2024
- In 2024, 3 Things You Must Know about Fake Snapchat Location On Realme C67 5G | Dr.fone
- 5 Best Route Generator Apps You Should Try On Honor 90 GT | Dr.fone
- In 2024, Top 7 Phone Number Locators To Track Samsung Galaxy F04 Location | Dr.fone
- Ultimate Guide from Xiaomi 14 FRP Bypass
- Title: How to Fix Errors were detected while saving Excel?
- Author: Nova
- Created at : 2024-05-19 18:32:11
- Updated at : 2024-05-21 02:34:22
- Link: https://blog-min.techidaily.com/how-to-fix-errors-were-detected-while-saving-excel-by-stellar-guide/
- License: This work is licensed under CC BY-NC-SA 4.0.