File Corrupted During Save - Attempts To Resurrect From Backup

Ark68

Well-known Member
Joined
Mar 23, 2004
Messages
4,616
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
After a few years of work on an Excel VBA project, today Excel crashed on me and the result was a corrupted file. Excel tried to fix it, and managed to do a decent job, but complex worksheets lost much of their formatting and who knows what else. Although the worksheets appear messed up, the code looks intact and current. My last backup was yesterday.

I have renamed the corrupted worksheets, and brought imported those worksheets back in from my backup. Of course there were a number of links needing updated in the worksheets that referred to the location of my backed up document rather than the current working copy. I had to adjust all the named ranges as well to remove the path.

But the workbook is messed up and it's preventing some references (macros etc) from changing.
In my VBA editor, I have a large number of excel sheets with the little Excel worksheet icon (Sheet1 - Sheet24), a large number of sheets that have my precrash worksheet names as Sheet25 (worksheet name) (sheets 25-48). I have workbook and workbook1. I only have 1 workbook open. How do I clean this up? Those extraneous worksheets do not exist in my workbook. (I think they belong to "Workbook1" which I have no idea where that is.)

The first problem I have experienced after this mess is a macro assigned shape on my main page. The assignment is 'SOP Schedule.xlsm'!sched_date. I've never had the leading file name before. If I try to remove it, it comes back. In the list of macros, sched_date exists, and even if I click on it, it populates to the full file name/macro. There are also oddly formatted macro names like sheet15.neg1 which I have never seen before (the macros yes, not how they are referenced). The macro assigned to the shape works.

Sorry if I'm rambling, but this is quite a setback. I'm uncertain how I can recover, I'm sure it will take some time. But I feel I need to clean up whats going on with the objects, whether they are remnants of the corruption, or from my backup attempts.
Capture.PNG
 
Last edited:

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Forum statistics

Threads
1,224,828
Messages
6,181,201
Members
453,022
Latest member
RobertV1609

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
Back
Top