Problem with Excel 2007 recovering from crash

  • Thread starter Thread starter TomCon
  • Start date Start date
T

TomCon

Excel 2007 crashed. Funny, the dialog box gave choices "send later" and
"don't send" which seemed odd to me (as i am used to "send now" and "don't
send"). I said "send later". Then, i got an alert, "Excel is recovering
your documents". However, Excel did not automatically relaunch, as it used
to. So, i started Excel. I do not see any recovered documents pane. I
opened the documents, and they are not the recovered ones, they are the last
saved ones. SO, it appears i have lost several hours work.

Is this a known issue with Excel 2007, that the recovery machinery is not
working as well as it was in previuos versions? Is there anything i can do
to find the documents i was working on when the crash occured? Its been
quite a few years since i had the paranoia of "save every few minutes
because the program might crash" but will that be necessary in Excel 2007?
I just hate it when "upgraded" products seem to regress and have more
problems than the old product it replaced!

Thanks for any suggestions. Tom
 
Tom

The recovered files are stored in the setting under Office Button>Excel
Options>Save>Auto recover file location. Depending on windows version you
may need to set the folder options in windows to show hidden folders.

Navigate to this folder under windows explorer. NOT through Excel and there
may be a randomly named file(s) with no file extension. Rename them to
xxxx.xlsx (if these were native 2007 files, else xxxxx.xls) and you will be
able to open them to see what you have

and no, I've seen no retrograde effects with auto-recover, but honestly, you
should always save regularly not rely upon a tools auto-recover as other
things could crash causing instability which may not trigger auto=recover in
Excel properly.

Also under the same tab, make sure auto-recover is switched on and the time
between saves is reasonable.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk
 
Tom,

I think I'm having the same problem with both Excel 2007 and Word
2007.

I described my Word 2007 problem in detail at the URL below:

http://groups.google.com/group/micr...11/806d7940336f2828?lnk=raot#806d7940336f2828

In the auto recovery folder of my Excel 2007 I have a couple of .xlb
files and one .xar file. I was able to open the .xar file via the open
and recover feature. But not the .xlb files.

So, I do think there's an error in how Office 2007 applications handle
their auto recovery features.

Thanks,
Andrew
 
Back
Top