An excel workbook I had been working on "crashed" and no longer opens. There is some sort of "apologetic" message that apears, asking if I wish to send a report to MS. Is there some way of repairing it? I had been saving it every few minutes while working on it, but did not think of saving it as different file name each time.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Cannot open Excel workbook
- Thread starter SacreBleu
- Start date
Did you have it backed up from your hard drive or on a server?
Chris
Sr. Mechanical Designer, CAD
SolidWorks 05 SP2.0 / PDMWorks 05
ctopher's home site
FAQ371-376
FAQ559-1100
FAQ559-1091
FAQ559-716
Chris
Sr. Mechanical Designer, CAD
SolidWorks 05 SP2.0 / PDMWorks 05
ctopher's home site
FAQ371-376
FAQ559-1100
FAQ559-1091
FAQ559-716
- Thread starter
- #4
ctopher,
The only "backup" consisted of an older version saved under a different file name, about a week ago (I lost about a week's worth of revisions to it).
I read in another thread that it would have been wise to have the "save backup copy" option turned on. Merely saving as a different file name is just as good.
Some possibilities that may have caused this: I was in the process of copy/pasting a worksheet from an Excel 2003 file to an Excel 1997 file. The "ASAP Utilities" add-in was running.
For some odd reason, this morning, none of my Excel files would open properly. I then tried uninstalling ASAP Utilities, and problem was gone (what the heck happened)
The only "backup" consisted of an older version saved under a different file name, about a week ago (I lost about a week's worth of revisions to it).
I read in another thread that it would have been wise to have the "save backup copy" option turned on. Merely saving as a different file name is just as good.
Some possibilities that may have caused this: I was in the process of copy/pasting a worksheet from an Excel 2003 file to an Excel 1997 file. The "ASAP Utilities" add-in was running.
For some odd reason, this morning, none of my Excel files would open properly. I then tried uninstalling ASAP Utilities, and problem was gone (what the heck happened)
PEStructural
Structural
Have you tried opening the file on another computer? Sometimes the XLStart file corrupts and you need to delete it and excel will write a new file when you first open it.
Try opening your corrupted file on another machine and see if it works.
Try opening your corrupted file on another machine and see if it works.
- Thread starter
- #6
PE,
It did open on another computer, but is worthless now. Only a few numbers showing, no text nor formatting, no formulae intact at all. There was a Excel message saying that the "damage" was too extensive. Sounds like a basic fault with Excel.
It did open on another computer, but is worthless now. Only a few numbers showing, no text nor formatting, no formulae intact at all. There was a Excel message saying that the "damage" was too extensive. Sounds like a basic fault with Excel.
- Status
