minus all the data. What happened? How do I recover?
Anyone whoâs used computers for any length of time has been in exactly this
same situation. I know I have.
And youâll find that most of us have developed a habit that you might want
to consider as well.
Become a Patron of Ask Leo! and go ad-free!
First, the short answer to your current situation is unfortunately simple:
the data is most likely gone, and you can only recover by starting over and
entering it again. I know that some will suggest convoluted approaches to
looking at temporary files, or worse, but in my experience that wastes more
time than just biting the bullet and starting over.
Why did it happen? Who knows? These are computers and âstuffâ (or a few
other words beginning with âsâ) happens. It shouldnât but it does. If it
happens too often there may be problems worth investigating, but âit frozeâ
isnât really enough to know where to begin.
So, knowing that it happens, and knowing that itâs bound to happen at
exactly the wrong time, what might you do differently the next time?
If you were to watch me type this article, youâd see me occasionally type
âCTRL+Sâ. That happens to be my editorâs âSave Documentâ shortcut. Because Iâve
been bitten by this exact same issue â sometimes bitten very hard â Iâve
trained myself to save the document âevery so oftenâ. Every page, every
paragraph, it doesnât really matter too much how often, just realize that if
something happens, youâll likely lose everything youâve done since the last
time you saved.
So far I think Iâve hit CTRL+S about 5 times. Itâs just become a habit.
I know that a lot of you are thinking that Excel (and Word, and other
applications) have something called âautosaveâ where they do something roughly
equivalent to my manually saving the document periodically. Thatâs very true,
and you should absolutely make sure those features are turned on. They have
also saved my work at times.
But there are two problems: sometimes they donât, and not all programs have
an auto-save feature.
But all of them have a manual save feature.
So, learn what the keyboard shortcut is to save your work in progress, and
get in the habit of doing so âevery so oftenâ.
Nope, you shouldnât have to; things should always just work and never
crash.
But we all quickly learn better.
Leo,
I have to give the latest version of Office props on this one (though I rarely do). Office 2007 and possibly earlier versions, have an auto recovery feature. Itâs not something I rely on in lieu of saving frequently, but it has saved me retyping a few paragraphs now and again when I get the random crashes that MS OSâs are well known for.
Iâm not sure if this is tied to the auto save feature or how it works, but if the system crashes, after I reboot, the next time I open the program, Word will say âyou didnât save these files before you closed, now what?â.
Again, NOT to be used instead of backing up, but you canât save ever minuet, but it can help. Now what I donât know is if this works when the actual office application crashes and burns. Ordinarily itâs another component that fails.
Leo,
I agree with what youâve said â but what if starting over isnât an option or represents many hours of work? Then a (one of the possibly multiple) temporary file might be valuable, even though it might not contain the most recent changes to the (formerly) active document. And as the computer froze, it probably didnât have time to deleted the temporary, invisible file it was creating while drafting the ârealâ document. So, one might go to a high level folder, select Tools:Folder Options:View:âShow hidden files and foldersâ. Then, using the Start:Search utility, search for unique text that ought to be in a cell in the spreadsheet. Then they should change that option back to âDo not show hidden files and foldersâ
Not too complicated, a little dangerous, but maybe not such a bad idea if starting over means hours of work, or completely lost. Although the white paper I reference here is oriented toward lawyers, it discusses how these multiple temporary invisible files get formed: http://www.burgessforensics.com/article_discovery.php
I totally agree with Leo. Iâve hit Ctrl-S so often in my years as a teacher, I think the nerves and muscles involved have become hardwired. Iâve been working with computers since my first Commodore 64 and my schoolâs Apple IIâs. It didnât take too many lost tests, lab instructions, and grade book pages before I bought into the mantra of saveâŠsaveâŠsave, and then save again. Whenever I pause to collect my thoughts, itâs Ctrl-S. At the end of each paragraph, itâs Ctrl-S. When I transfer the toothbrush from one side of my mouth to the other, itâs ⊠no, strike that one. I never need to retype more than 5 minutes of work.
There are other tricks, too. When writing long e-mails, do the composition in a simple text file. Then, if you need to open a search box or look up a file on your computer or network, everything youâve written is still there. (Assuming, of course, that you saved before you opened another window or tab.) When youâre done writing, copy and paste into the body of the e-mail. As an added bonus, you have the text of your message stored in a separate file.
One pet peeve of mine is software that uses anything other than the standard key sequences (Ctrl-S, Ctrl-C, Ctrl-V, etc). Itâs much better now than a few years ago, thanks to the proliferation of standards for Windows (and Macs, I assume, although I know almost nothing about them). But there is still the occasional âfree spiritâ programmer who thinks it is good for users to reexamine their habits. They should be exiled to a deserted island to ponder their misguided notions.
A similar bad one is is situations like now: typing comments into a page or forum, then submitting it only to have it say âunexpected error, now your doneâ, I make it a habit before I submit I select all the text, right click, copy, then if all goes well I forget it, and if it plays up I can paste it back in.
Iâve used Wordâs (and other MS Office programs)autosave feature for years â set to every 5 minutes, and it has saved me untold minutes/hours of work when the power fails, the computer freezes or what have you. It actually works better than most MS Office features IMHO.
Sometimes I remember to save manually, but often not, so itâs well worth setting the autosave to something near-term, every 5 minutes has worked very well for me over the years.
Cheers,
Lelani
While sending an e-mail and I do âCTRL+Sâ and lose my e-mailâhow do I get it back?