Excel will not open spreadsheet. Any recourse?

matthume

New Member
Joined
Oct 19, 2002
Messages
11
I was working on a workbook with Excel 2000 (9.0) and closed it uneventfully. Upon reopening Excel crashes with the "EXCEL.EXE has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created." Enabling or disabling macros has no effect on this eventuality.

Do I have any recourse? Would it be possible to open the Excel file using VB and disable parts of it looking for the offending code?

Thanks.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Damon Ostrander

MrExcel MVP
Joined
Feb 17, 2002
Messages
4,239
Hi Matt,

I recommend you check out some of the many sites on the web that offer Excel file recovery. Some of them allow you to try the software for a trial period before purchasing. I believe there is a link to one that MrExcel recommends on the MrExcel.com home page.

Oh, and one other thing...it is not enough to save your file frequently. You should also save checkpoint versions periodically.

Damon
 

matthume

New Member
Joined
Oct 19, 2002
Messages
11
I appreciate the reply, Damon. I am working with one recovery program right now. I am not expecting much as quite a bit of the lost work is on charts and most recovery programs do not recover objects. I was just wondering what experience others have had with problems of this type.

Believe me, I understand the need for incremental backups for situations like this. I normally do a good job of using Save As frequently. But of course not this time. You would think I would know better after 20 years on these things.

Thanks.
 

I_AM

Board Regular
Joined
Jul 2, 2002
Messages
139
I had a simaler problem, there was no way excel would open the book. As a last resort I tried opening it with a free office product, and hey wha lah! Was then able to save As- as an Excel file
 

matthume

New Member
Joined
Oct 19, 2002
Messages
11
What do you mean by a free office product? I would be interested in trying this.
 

matthume

New Member
Joined
Oct 19, 2002
Messages
11
Many thanks, Ron!!! I was able to open my file in the 602Tab application from Software 602 PC Suite, http://www.software602.com. The charts still caused problems, but I was able to retrieve all data sheets in my workbook. I did have to use Task Manager to end the graphing task MGRAF.EXE several times before I could gain control of the program and save the file as an XLS.

I feel that one of two things happened that corrupted this file. 1. I had screwed up a reference on one of my controls or had too many controls on a chart. 2. I had deleted about 1000 rows of data from one sheet prior to my problems. When I saved the changes, I used Save rather than Save As. I thought perhaps there were some issues with writing the same file name with substantially less data. My charts had a number of controls from the Forms toolbar. Perhaps they were too complex to open in 602Tab.

In my case, using 602 retrieved substantially more data than the recovery utilities sold for this purpose. My recovered copies had many formulas converted to values.

All in all, this error cost me about 15 hours of development time, but my regenerated spreadsheet is better written and more cohesive. And the experience brought my attention back to my backup plan.
Save every 15 minutes.
Save As with revision number every hour.
Exit program and reopen file after every Save As. In my situation Excel continued to function normally even though the file it had written to disk would not open.
Replicate files to second computer every 8 hours
With this method I should never lose more than 1 hours work unless I suffer a catastrophic equipment failure in which case I could lose up to 8 hours.

I highly recommend that others keep 602Suite in mind if they ever encounter problems opening a file.
 

Forum statistics

Threads
1,144,112
Messages
5,722,539
Members
422,446
Latest member
jsasiadek35

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