How to fix Errors were detected while saving files in Excel 2010

Microsoft Excel office tools are currently popular software in handling data tables and charts. However, in the process of using the user will encounter some errors affecting the process of creating and processing Excel file data. For example, when you save the file, an error message will appear "Errors were detected while saving the file . Microsoft Excel may be able to save the file. To cancel saving the file, click Cancel ".

When this error occurs, we cannot save the current file to an old file. Save or Save as to a new file will not work. So how can I solve the error that can't save Excel file?

This error may occur because we are working on VBA (Microsoft Visual Basic for Applications editor), or the directory path to the file exceeds the number of characters and the Vietnamese language contains the mark.

Step 1:

When the above message appears, we need to exit the corrupted file. Then click the File> Open button and navigate to the path containing the file. Open the option at the small arrow next to the Open button and select Open and repair .

Note, when we exit the error file, all edited content will disappear.

Step 2:

Appearance dialog box opens. Here click on Repair to proceed to repair the corrupted file. Finally you just need to press Save to save.

In addition, users can also perform the method of clicking Save as the file to the Desktop or C: drive with a shorter path. Or you can create a blank Excel file and copy the new spreadsheet content. However, this method is only suitable for spreadsheets with simple content.

Above is how to fix the error of not saving the file during the process of saving content or creating new content on Excel. If your Excel content is quite simple, you can copy the content to a blank Excel file and save it. However, the best way is to click Repair to fix the file according to the instructions above.

Refer to the following articles:

1. These are the most basic functions in Excel that you need to understand
2. 10 ways to recover corrupted Excel files

1. 10 ways to use the Paste feature in Excel

1. Summary of expensive shortcuts in Microsoft Excel