MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Cannot open saved file HELP!!!


Posted by dennisgroup on December 09, 2000 2:38 PM

The instruction at "0x77f6481a" referenced memory at "0xfffffff8" The memory could not be "read" Click on ok to terminate the application. AND

The instruction at "0x77f64e2e" referenced memory at "0xfffffff8" The memory could not be "read" Click on ok to terminate the application.


Posted by FredF on December 11, 2000 5:40 AM

Reply:

The following procedure works, but not in 100% of the cases...and it will not recover the formulas - formulas will be pasted as values. You'll have to rebuild the formulas.

If you know the exact path and filename of the xls file, do the following:

(1)Open Excel and start a new workbook (file, new).
(2) Move your mouse pointer to cell A1
(3) In the formula bar, type the following, replacing C:\MyDocuments\[bad file.xls] with the exact path and file name for the unreadable file. replace Sheet1 with the name of the first sheet.

=+'C:\MyDocuments\[bad file.xls]Sheet1'!A1

(4) Copy the formula from A1 to every cell where you think you have data. Be careful not to copy to the entire wookbook, as this will take a long time or it may crash.

(5) If the formulas work, range select all the formulas, copy to the clipboard and then from the menu bar, select: edit, paste special, values. The cells will all become values - no formulas.

If you have multiple sheets in the workbook, you will need to repeat this procedure for each sheet, changing Sheet1 with the actual sheet name.

If you have objects from the drawing tools, these will not be recovered - only cell contents.

If you have formatted cells, the formatting will not be recovered.

There are probably some other things that won't recover, but the most important parts - your data will be intact. If you have lots of formulas, this may not be the best solution.

This will not cause any damage to your original unreadable file

Also, if the file is on a network, try opening the file on another workstation. I'm sure you've tried just about anything

Good luck!