Excel Crashed Data Recovery

[TidyTrax]

I was working on a spreadsheet when excel crashed, anyone know of a way of recovering the lost data?????? Its Office 2000

 

[DPlank]

There is a forum for General Data Recovery on TT if no-one here has any helpful tips for you.

Sorry I can't be of more help.

Cheers,
Dave

Probably the only Test Analyst Manager on Tek-Tips...therefore whatever it was that went wrong, I'm to blame...

animadverto vos in Abyssus!

Take a look at Forum1393!

 

[BobStubbs]

I know it's too late for your current problem, but there are two things you can do in Excel to protect yourself in the future. I don't know why Microsoft make them so difficult ... they are both much easier to do in Word!

1. Install the AutoSave add-in, and set it up to perform an AutoSave on the active workbook every ten minutes. In this way, a system or application crash will never cost you more than a few minutes' worth of data. To do this:

-- Choose the Tools ... Add-Ins menu option
-- Find the AutoSave Add-in in the list, and check its check box.
-- Click [OK]
-- Now choose Tools ... AutoSave
-- Set the time period and other options as you require, and click [OK]

Note: Once you install AutoSave, it works for all workbooks which you open.

2. Switch on the 'always create backup' option:
-- Open your workbook
-- On the File menu, click Save As.
-- On the Tools menu, click General Options.
-- Select the Always create backup check box.
-- Click OK, and then click Save.

Now, each time you open the workbook, Excel makes a backup copy (file name extension .xlk) for you. You can always go back to this if the open workbook is badly damaged.

Note: This option has to be set for each workbook ... I can't find a way to set it in a template, but you could create your own 'template workbook' with this option set, and just copy it as required.

I hope that this information will be of some help in the future.

Bob Stubbs (London, UK)

 

[KenWright]

You may prefer Jan Karel's Autosafe addin that uses a different directory to store a temp backup file until you close Excel:-

http://www.oaltd.co.uk/MVP/Default.htm

(Note it is AutoSafe.zip and NOT AutosafeVBE.zip)

I often try different scenarios on my data models and rely on undo to get back to a previous state, so I would never use the MS Autosave option for that very reason.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------