Corrupt Excel File, I'm Toast! I'm beggin here...

[Bull Splat]

Spent the past several days grinding out a spreadsheet, and I've been
carefull to save repeatedly.

Just ready to run the print off for the meetings this week, and it
crashed...

Running Win Mil, Excel 2000.

I get an Excel has caused an Error in Excel.exe. I booted into Safe
mode, same error. I tried loading the file with out enabling macros,
same error. I can load other .xls spreadsheets, just not the master
one.
I loaded the file onto another computer, same error.

Think I'm going to be sick here....


Here's the error.

Date 02/07/2004 Time 13:17
EXCEL caused an invalid page fault in
module EXCEL.EXE at 016f:30111233.
Registers:
EAX=006261eb CS=016f EIP=30111233 EFLGS=00010216
EBX=006261e4 SS=0177 ESP=006261b0 EBP=006261c0
ECX=000ffff0 DS=0177 ESI=0062ae68 FS=2127
EDX=01c2000c ES=0177 EDI=00007fff GS=0000
Bytes at CS:EIP:
8b 74 11 0c 8d 4c 11 0c 66 8b 56 06 8b fa 83 e7
Stack dump:
00007fff 0062ae68 0062ae62 ffffffff 00626358 30263f50 006261e4
0000003a 00000000 00000008 01cb409e 0062ae5a 0062ae50 08ffff3a
01001700 00626210


Any suggestions? THanks...

 

[Ken Wright]

Could be any number of things. Will it open on anyone else's machine - If so
then do a search for your *.xlb file and trash it or rename it to *.old (Its a
toolbar customisation file, and Excel will create another one, though you do
lose any customisations obviously). If you have access to Excel XP or 2003 then
you could get someone to try the repair option for you. If you don't, then by
all means fire it down to me if you can and I'll have a go for you. OpenOffice
is also good at opening corrupt Excel files.

Sometimes with repaired files though you only get back the raw data and not all
the formulas.

If yo do want to mail it to me then take the NOSPAM out of email my address.

 

[A.W.J. Ales]

Maybe not enough, but I heard that Star Office (free program as far as I
know) often can open Excel files which Excel itself can't open anymore.
I'm not sure wether your formula's are retained or that you will only get
values (if it does work at all).
And most likely that it will not include your macro's.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Tom Ogilvy]

If you have/know someone with xl2002/2003, it has a repair feature that
**Might** be able to open it.

Alternative it so download OpenOffice, install it, and see if you can open
it with that.

Or it may just be gone.

Along with saving repeatedly, you need to make backups.

 

[KJTFS]

I would try the different versions of excel xp and up (if you hav
access to them) then I would try the Open Office or Star Office option
one of my teachers was able to recover a file in Star and swears by it
Only help I have, also your error message remindend me of my assembl
class, scary.....

Keith
www.kjtfs.co

 

[Bull Splat]

Thanks to all that responded. OpenOffice did open the file, but it
couldn't replicate the extensive formatting, chart options, etc.

I had been saving this file frequently with new file names, but I
stopped doing that when the macros wouldn't work across multiple
workbooks (I had to go into the each macro and search and replace the
name of the workbook to get the macro to run). I'm certain that this
is due to a novice understanding of the programming side of Excel, and
I've since started saving all of my Macros in a macro worksheet where
they're available to all worksheets, but I still run into minor
problems as far as workbook names.

So, the good news is "I saved a Ton of Money on my Insurance", whoops,
sorry, the good news is all of the macros I created are still
available in the macro worksheet, and I've lost only a day of work as
far as getting this project delivered.

Thanks again to all, this forum is great!

 

[Tom Ogilvy]

ThisWorkbook refers to the workbook containing the code, obviating the need
to include a hard coded name.