recovering workbooks

janet · Mar 14th, 2002, 02:00 PM

Is there any way of recovering workbooks that crash. If this happens in Word when you re-open the file it does an Auto Recovery is there anything similiar in Excel 2000?.

thanks

Al Chara · Mar 14th, 2002, 02:10 PM

There is an autosave feature for download created by Jan Karel Pieterse. You can find it on this page:
http://www.bmsltd.co.uk/MVP/MVPPage.asp

I hope this helps.
Kind regards, Al.

Jack in the UK · Mar 14th, 2002, 03:30 PM

Hi

Excel already has add in autosave which you can activate, if you have poper copy of Excel, and the disk may be needed, this can be set easy via tools bar.

Also in VBA can be called fron ONTIME command...

But to answer.

Not many of us Exceller know Word and Excel are ver different in workings, forget word processings and maths spreadsheets, but in workings, i mean take save Word have very advanced technology to do this thus autoorecoveries files you can get, Excel DONT.

The way Word saves is very powerful and complex it "ontheflys" saves excel dont, excel crunch saves so now recovery files.

Assesnment Excel save is poor, remember to BACK up can be custon to set save as and back up at same time evey X minutes...

ALWAYS BACK UP and ALWAYS ALWAYS hit Ctrl+S every 10 seconds or less (i really mean As Much A poss) as you work, or leave desk

I have been told Microsoft have sorted emproved the technologys to save in Excel but XP has not got to Word 97 standards yet, ... maybe soon...

Mar 14th, 2002, 03:30 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi Excel already has add in autosave which you can activate, if you have poper copy of Excel, and the disk may be needed, this can be set easy via tools bar. Also in VBA can be called fron ONTIME command... But to answer. Not many of us Exceller know Word and Excel are ver different in workings, forget word processings and maths spreadsheets, but in workings, i mean take save Word have very advanced technology to do this thus autoorecoveries files you can get, Excel DONT. The way Word saves is very powerful and complex it "ontheflys" saves excel dont, excel crunch saves so now recovery files. Assesnment Excel save is poor, remember to BACK up can be custon to set save as and back up at same time evey X minutes... ALWAYS BACK UP and ALWAYS ALWAYS hit Ctrl+S every 10 seconds or less (i really mean As Much A poss) as you work, or leave desk I have been told Microsoft have sorted emproved the technologys to save in Excel but XP has not got to Word 97 standards yet, ... maybe soon... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 14th, 2002, 02:00 PM	#1
janet New Member Join Date: Feb 2002 Posts: 3	Is there any way of recovering workbooks that crash. If this happens in Word when you re-open the file it does an Auto Recovery is there anything similiar in Excel 2000?. thanks

Mar 14th, 2002, 02:10 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	There is an autosave feature for download created by Jan Karel Pieterse. You can find it on this page: http://www.bmsltd.co.uk/MVP/MVPPage.asp I hope this helps. Kind regards, Al.