File always opens with the same repairs

DLamp

New Member
Joined
Sep 9, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

jondavis1987

Active Member
Joined
Dec 31, 2015
Messages
413
Office Version
  1. 2019
Platform
  1. Windows
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

New Member
Joined
Sep 9, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
52,939
Office Version
  1. 365
Platform
  1. Windows
Did the macro delete existing sort fields before re-sorting?
 

Watch MrExcel Video

Forum statistics

Threads
1,122,530
Messages
5,596,699
Members
414,088
Latest member
rodriboraun

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top