Recover Back up files

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I finished working on a large file and went to save it when i got an error
and Excel shut down on me. I went to the location where Excel saves the back
up with the extension of .xlb and have tried to open it. All I get is a new
work book and the file never opens. Is there a way to open the .xlb file that
i am not doing?
 
First of all.........backup files are *.xlk files. *.xlb is the file that
saves your customizations.

Second of all..........how were the backup file(s) created?

Using the "always create a backup" from File>Save as Tools>General Options or
are you speaking of the files Excel creates under Tools>Options>Save?

If the latter, Excel should have presented you with a file to recover if Excel
crashed while you had the file open. Did it not?

Try going to C:\Documents and Settings\username\Application Data\Microsoft\Excel

Look for a *.xar file.

Change extension to .xls and see if it opens.

You might get lucky.


Gord Dibben MS Excel MVP
 
Back
Top