WHAT HAPPENED!!!!

[vonderay]

I save a model in excel - simple sums and totals financial model -
several times during the day and it crashed. now the latest version is
the one I save YESTERDAY!!!!! ARGH!!!! What happened??? how do I fix
this and recover my file!?!?!?!


thanks

 

[little_creature]

Steps hat can help solve doccument corruption:

*I would check or temporary disble links to other files
(if there ever been any there might be some parts still even you cannot see
it, the you should use utility to remove all bits)
http://www.bmsltd.ie/MVP/Default.htm

* You might try to remove all macros included in woorkbook (if needed
afterwards you can copy it from older version of the corrupted file) (check
both Workbook module and sheet modules.)

*I woud also check all formulas

*You might search for "bad" characters as well - if you push
CTRl+shift+arrows should put you on your last record in column/row, if not
there§s somewhere bad character - then I would copy all your data by bits
into new workbook

*might try to ShowSave the file in SYLK format

 

[vonderay]

what i dont understand is that i saved the NEW file several times and
it reverted to an old file? how did it do this? how does the os know
to go to "which" file???

 

[Bob Greenblatt]

what i dont understand is that i saved the NEW file several times and
it reverted to an old file? how did it do this? how does the os know
to go to "which" file???

I can't tell you exactly how it happened, but when Excel saves a file, it
first creates a new invisible copy with an internal file name. If the save
is successful, it deletes the original copy, renames the new file from the
internal name to the original name and makes it visible. If it crashed
during this process I can see how the named copy might be the original file
if it had not yet had a chance to delete and rename files. Create a backup
when you save - do a save as (use the same name and location), click on
options and check Always make backup.

Are you saving to a network drive? If so, save it locally and then copy to
the network when you are done.

 

[vonderay]

thanks - good advice.

I can't tell you exactly how it happened, but when Excel saves a file, it
first creates a new invisible copy with an internal file name. If the save
is successful, it deletes the original copy, renames the new file from the
internal name to the original name and makes it visible. If it crashed
during this process I can see how the named copy might be the original file
if it had not yet had a chance to delete and rename files. Create a backup
when you save - do a save as (use the same name and location), click on
options and check Always make backup.

Are you saving to a network drive? If so, save it locally and then copy to
the network when you are done.