File always opens with the same repairs

[DLamp]

I have an xlsm file that, for reasons I can not understand, opens with the message:

"We found a problem with some content in FILENAME.xlsm. Do you want us to try to recover as much as we can?"

I choose yes and the workbook opens with the following repairs message:

Excel was able to open the file by removing the following unreadable content:
Repaired Records: View from /xl/worksheets/sheet1.xml part
Repaired Records: View from /xl/worksheets/sheet3.xml part
Repaired Records: View from /xl/worksheets/sheet4.xml part
Repaired Records: View from /xl/worksheets/sheet5.xml part
Repaired Records: View from /xl/worksheets/sheet6.xml part
Repaired Records: View from /xl/worksheets/sheet7.xml part
Repaired Records: View from /xl/worksheets/sheet8.xml part
Repaired Records: View from /xl/worksheets/sheet9.xml part
Repaired Records: View from /xl/worksheets/sheet10.xml part
Repaired Records: View from /xl/worksheets/sheet11.xml part
Repaired Records: View from /xl/worksheets/sheet12.xml part
Repaired Records: View from /xl/worksheets/sheet13.xml part
Repaired Records: View from /xl/worksheets/sheet14.xml part
Repaired Records: View from /xl/worksheets/sheet15.xml part
Repaired Records: View from /xl/worksheets/sheet16.xml part
Repaired Records: View from /xl/worksheets/sheet17.xml part
Repaired Records: View from /xl/worksheets/sheet18.xml part
Repaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: VRepaired Records: V

Thereafter the workbook seems to work with all functionality. When I try to save, I am forced to Save As. When reopening the file after Save As (including when changing file name) the exact same problem repeats. The problem is true opening the file with different users/devices.

What is particularly odd, is that when I restore an old back up of the file, obviously from before the problem, it opens without the error/corruption. However, as soon as I save and reopen said back up, the problem arises.

Would be grateful for any help.

 

[jondavis1987]

Try this

Open Excel and select “File” on the taskbar. Then click Save or Save As. Then click Tools. From the list, click on the “General Options” tab and select the “Read-only” checkbox.

Now open the new, empty .xls file. Next, you need to copy everything from the damaged file to the new file. After that, save the file.

 

[DLamp]

Try this

Open Excel and select “File” on the taskbar. Then click Save or Save As. Then click Tools. From the list, click on the “General Options” tab and select the “Read-only” checkbox.

Now open the new, empty .xls file. Next, you need to copy everything from the damaged file to the new file. After that, save the file.

Thank you for the suggestion.

This was my firs thought too but Due to the number of shapes/buttons, whose references change when copying to a new file and many other references that need updating it would be too time consuming.

For the benefit of anybody with the same problem, I have established that the problem is somehow linked to sorting sheets with vba using .SortFields. Add Key. By removing the offending macro I have been able to resolve the problem, although I can't actually identify exactly what the problem was.

 

[Fluff]

Did the macro delete existing sort fields before re-sorting?