is there any fix for the error "Errors were detected while saving (filename)"

Sameer Kuppanath 1 Reputation point
2023-05-16T13:29:57.1166667+00:00

I have been facing the issue of saving excel file,

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,604 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Tanay Prasad 2,110 Reputation points
    2023-05-17T06:09:32.9333333+00:00

    Hi Sameer,

    This error can error due to various reasons like corrupt VBA code, file version incompatibility, pivot table issues, and even due to corruption in Excel files.

    But not to worry, there are easy ways to fix it-

    1. Open Excel in Safe Mode and Disable Add-ins-
      1. Open the Run window by pressing Windows key + R.
      2. Type excel /safe in the Run window.
      3. click on OK.
      4. go to the File tab and click Options.
      5. In Excel Options, click on the Add-ins
      6. Under the Manage section, select Excel Add-ins and then click on the Go
      7. In the Add-ins dialog box, unselect the add-ins under the Add-ins available option and click OK.
    2. Open and Repair-
      1. Open Excel and go to "File" > "Open."
      2. Navigate to the location of the problematic file.
      3. Instead of directly opening the file, select it and click the arrow next to the Open button.
      4. Choose "Open and Repair" from the dropdown menu.
      5. Excel will attempt to repair the file. If successful, save the repaired file with a different name.

    This should work out for you. But if they don't, I'd say you refer to this article.

    Best Regards.

    1 person found this answer helpful.
    0 comments No comments

  2. Emi Zhang-MSFT 23,031 Reputation points Microsoft Vendor
    2023-05-17T08:55:10.96+00:00

    Hi,

    Did this problem appear in all Workbooks?

    Where did you save it? In local desktop or cloud?

    I suggest you read this article about how to troubleshoot save problems:

    https://learn.microsoft.com/en-us/office/troubleshoot/excel/issue-when-save-excel-workbooks?tabs=third-party

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.