Errors were detected while saving file in Excel 2010

Anonymous
2010-09-01T16:04:55+00:00

I get the error "Errors were detected while saving 'C:\Users\Filename.xlsx. To make repairs in a new file, click continue. To cancel saving the file, click cancel" The appears to be no pattern to this. Does any have a solution. All similar questions in the forum don't offer a solution to this error message.

Microsoft 365 and Office | Install, redeem, activate | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2011-11-11T09:58:36+00:00

I have had this issue recently and it turned out to be a company logo which was in the top right of each worksheet.I removed this (.png) image from each sheet, the workbook did not then give an error saving. I then opened the logo and re-saved it as a .jpg and then re-added it to each sheet. The workbook continued to save quite happily.

Hope this helps

Was this answer helpful?

300+ people found this answer helpful.
0 comments

48 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2010-09-01T19:38:16+00:00

    On Wed, 1 Sep 2010 16:04:55 +0000, Wheels482003 wrote:

    I get the error "Errors were detected while saving 'C:\Users\Filename.xlsx. To make repairs in a new file, click continue. To cancel saving the file, click cancel" The appears to be no pattern to this. Does any have a solution. All similar questions in the forum don't offer a solution to this error message.

    Tried these suggestions?

    http://support.microsoft.com/kb/271513

    Gérard

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2010-09-02T12:19:54+00:00

    Do you get this error message while saving a specific Excel file or all Excel files?

    Verify the same with a new Excel file.

    Try to save the file to a different location and verify the status.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  3. Anonymous
    2010-12-29T23:21:01+00:00

    Hi Wheels482003,

    Were you able to get this problem solved?  I am dealing with the exact same issue.

    Steelpirate

    Was this answer helpful?

    0 comments
  4. Anonymous
    2011-03-19T17:39:25+00:00

    Success!

    My encounter with this error is with Excel 2007 SP2

    Error resulted in unrepairable errors in the workbook.

    Characteristics of workbook

    • 20 worksheets
    • references between the various worksheets
    • a few charts, one copied from another workbook, although I believe all data for the chart was local to the sheet on which it was placed.
    • one of the sheets with a pie chart was duplicated, but was not associated with data beyond the scope of the worksheet itself, no named ranges, etc.
    • No Pivots
    • No External Data Sources.
    • a few named ranges (less than 10)
    • some merged cells

    Initial Recovery Attempt

    • "Limited Save" resulted in a loss of all the graphics and intersheet formulas

    Successful Recovery

    • Removed the graph that had been copied in from another workbook
    • Then, Sheet by sheet:

    --Selected all cells in the sheet (not "Select all" or CTRL-A, rather clicked on the upper-leftmost widget to select all cells in the sheet

    --CTRL-C  to copy

    --CTRL-V to paste

    • Interestingly, the full paste Unmerged previously Merged cells. could be co-incidental, but thought I should mention it.
    • Saved to a new file. (may not have been necessary, but wanted to hold on to the last successful save point in case it failed.)
    • Have been working with the file and saving it without error.

    My two cents

    • I believe copying and re-pasting the cells forced a "re-resolution" and "re-calculation" of the formulas, with worksheet and range references.
    • The unmerging of cells was a meddlesome but tolerable side effect. I may have been able to avoid this, but need to move on...

    Was this answer helpful?

    5 people found this answer helpful.
    0 comments