MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I forgot to save my data.

Posted by Jeff Noel on August 24, 2001 8:49 AM

After working on a project for several hours in a Ecel spreadsheet, I forgot to save my data. Is it possible to get back all my lost data? Please help.

Posted by Tom Urtis on August 24, 2001 9:26 AM

Re: Ouch, sounds like an unhappy ending

Hi Jeff:

Not the answer you are hoping for, but it sounds like your data is gone for good. You're in good company, it has happened to beginners and advanced users alike. Not to sound funny, but this experience is like forgetting your mother's birthday -- do it once and you won't forget it again. You might try using the AutoSave feature. Good luck to you.


Posted by anon. on August 24, 2001 11:55 AM

forgot to save my data: Not bad enough for the Darwin Award.

Posted by Been there, done that on August 24, 2001 12:15 PM

Re: forgot to save my data: Not bad enough for the Darwin Award, but you've got to's close!

Posted by BARRETT South london on August 25, 2001 10:53 AM

PAINFUL But.... not to get excited thou!

:: OK Autosave is the answer, but be careful, Autosave is poor and trashs xls files, just a geeky thing. CTR+S or button save.

TOP TIPS: i work in finance on 200 uesr network and data loss will happen. I tell EVERYONE this

CTR+S everytime you swith sessions so got to databse

CTR+S when you leave your desk (NO matter what)
Also try to put add-in Auto save and set to one minute so crash less painful.

Im working on VBA to save a little diff E2002 save better - but i haver not been caught out in 10 years now and many others have and will.

Sorry mate, if you had once saved it go looking in temp or recovered docs (xls) start find *.xls else its bad news.

Exl does ask save or not if you close ??? odd that.