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.

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

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.

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

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.

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

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
4.5 ★ | 6 Vote

May be interested

  • How to fix Value errors in ExcelHow to fix Value errors in Excel
    how to fix value errors in excel. working with excel sometimes you will encounter #value! but you guys don't know how to fix this. there are many causes of #value! error, below article will give some of the most common value errors in excel and
  • How to fix 'Hard Drive Not Detected' error on WindowsHow to fix 'Hard Drive Not Detected' error on Windows
    if you start your pc as usual, but instead of the usual desktop screen, you encounter the hard drive not detected error message on windows.
  • How to fix Autofill errors in ExcelHow to fix Autofill errors in Excel
    are you facing autofill problems in excel? here are some ways to help you quickly fix data autocomplete errors in microsoft excel.
  • Common causes of Excel workbook errorsCommon causes of Excel workbook errors
    lost your work on excel due to file corruption? understanding the errors that cause damaged excel files will help you avoid that from happening.
  • Common errors in Excel and effective ways to fix themCommon errors in Excel and effective ways to fix them
    when working on excel, many people encounter errors such as #value!, ##### or #ref! that interrupt their work. these errors are often caused by incorrect formulas, data formats or reference errors. below are the causes and solutions to help you handle them quickly.
  • Common mistakes in Excel and how to fix themCommon mistakes in Excel and how to fix them
    common errors in excel and the most detailed troubleshooting guide
  • Excel 2016 - Lesson 2: Learn about OneDrive - Complete guide to Excel 2016Excel 2016 - Lesson 2: Learn about OneDrive - Complete guide to Excel 2016
    in the introduction of the excel 2016 section, tipsmake.com helped you get acquainted with microsoft excel. today, we continue to share with you what you need to know about onedrive. please join us!
  • Fix error when Excel file is minimizedFix error when Excel file is minimized
    occasionally, when printing an excel file, you often encounter a file error that is automatically shrunk. how to solve this problem is not difficult, just do it with 3 steps ...
  • Fix iTunes error: 'An iPhone Has Been Detected But It Could Not Be Identified'Fix iTunes error: 'An iPhone Has Been Detected But It Could Not Be Identified'
    if connecting an iphone or ios device to a windows computer, in some cases an error will occur and this makes the user feel uncomfortable. recently, many users reflect that in the process of connecting iphone to windows computer, they received an error message saying 'an iphone has been detected but it cannot be identified'. although tried many different ways, using another usb cable, changing the usb port, ... but still cannot fix the error.
  • How to compare 2 Excel files to see if there is any differenceHow to compare 2 Excel files to see if there is any difference
    if you work with excel spreadsheets regularly, we can easily find out the differences on excel files. but if you are new to excel and you have to compare 2 excel files to see what is different but do not know how? please follow the article below to answer that question!