I have a very important workwook in Excel 2007 - and therefore ensure that
it automatically creates a backup of the file itself when it saves.

Just now I tried to save as usual and it told me there was a problem - a
couple of dialogue boxes later it told me that the file was so badly
corrupted that it had been removed (!), but saved in another setting in
Documents and Settings and Excel shut down.  On checking my directory it had
also deleted the backup - WTF?!

So I rummaged around in Documents & Settings/Application Data/Excel and
found the temporary/recovery file that it had created.  On opening this file
it says that it needs to recover the data - and it manages to recover some
of one of the sheets, but the other sheets are just blank (no gridlines,
nothing).

Help - I think that this is shocking behaviour for Excel... it has completed
corrupted a really important workbook, deleted it and deleted the backup
copy.  Totally unacceptable.

Any ideas?  Help much appreciated.

Will