tloonya
Junior Associate
What status?
Joined: Dec 18, 2010 16:22:13 GMT -5
Posts: 8,452
|
Post by tloonya on Sept 4, 2012 13:44:12 GMT -5
I have been working on Excel spreadsheet without closing it for 4 days. Then it got closed somehow. Does it mean I lost it? I always thought it is saves automatically every 15min or so???
I am ready to go hang myself!!! Hours of work...lost???
|
|
swamp
Community Leader
Don't be a fool. Call me!
Joined: Dec 19, 2010 16:03:22 GMT -5
Posts: 45,333
|
Post by swamp on Sept 4, 2012 13:44:44 GMT -5
um, no.
|
|
Miss Tequila
Distinguished Associate
Joined: Dec 19, 2010 10:13:45 GMT -5
Posts: 20,602
|
Post by Miss Tequila on Sept 4, 2012 13:48:14 GMT -5
Mine has an autorecovery that will bring up the last version in the event of an unexpected closure.
|
|
Deleted
Joined: May 7, 2024 5:59:48 GMT -5
Posts: 0
|
Post by Deleted on Sept 4, 2012 13:49:06 GMT -5
loony,
are you making meth in your bathtub again?
|
|
tloonya
Junior Associate
What status?
Joined: Dec 18, 2010 16:22:13 GMT -5
Posts: 8,452
|
Post by tloonya on Sept 4, 2012 13:50:03 GMT -5
I am Win XPeeeeeeeeeee No it didnt ask if something got closed...to re-open... Why wouldn't it save??? Whyyyyyyy???
|
|
tloonya
Junior Associate
What status?
Joined: Dec 18, 2010 16:22:13 GMT -5
Posts: 8,452
|
Post by tloonya on Sept 4, 2012 13:50:37 GMT -5
Mine has an autorecovery that will bring up the last version in the event of an unexpected closure. Where did you get it?
|
|
Wisconsin Beth
Distinguished Associate
No, we don't walk away. But when we're holding on to something precious, we run.
Joined: Dec 20, 2010 11:59:36 GMT -5
Posts: 30,626
|
Post by Wisconsin Beth on Sept 4, 2012 13:51:58 GMT -5
You may be able to find it on your temp files, if you can get to them. I never can get there on my computer but maybe someone else can guide you though the steps/clicks to get there?
|
|
tloonya
Junior Associate
What status?
Joined: Dec 18, 2010 16:22:13 GMT -5
Posts: 8,452
|
Post by tloonya on Sept 4, 2012 13:52:40 GMT -5
loony, are you making meth in your bathtub again? I can definitely drown you in it. Common over!
|
|
thyme4change
Community Leader
Joined: Dec 26, 2010 13:54:08 GMT -5
Posts: 40,415
|
Post by thyme4change on Sept 4, 2012 13:52:47 GMT -5
blocked due to malware/-dwLTXAGvG_I/TdGbZxp4sKI/AAAAAAAAHbI/py03MHdMqWM/s1600/DoubleFacePalm.jpg[/img]
|
|
Deleted
Joined: May 7, 2024 5:59:48 GMT -5
Posts: 0
|
Post by Deleted on Sept 4, 2012 13:55:55 GMT -5
loony, are you making meth in your bathtub again? I can definitely drown you in it. Common over! I wish I could. I would console you properly. There are companies and products that can help you recover info like this from you computer. It may cost a few bucks, though.
|
|
tloonya
Junior Associate
What status?
Joined: Dec 18, 2010 16:22:13 GMT -5
Posts: 8,452
|
Post by tloonya on Sept 4, 2012 13:57:45 GMT -5
You may be able to find it on your temp files, if you can get to them. I never can get there on my computer but maybe someone else can guide you though the steps/clicks to get there? Whats the name of the folder? Temp or???
|
|
tloonya
Junior Associate
What status?
Joined: Dec 18, 2010 16:22:13 GMT -5
Posts: 8,452
|
Post by tloonya on Sept 4, 2012 13:59:12 GMT -5
I am finishing a whole bag of cookies!!!!!! HELP dammit!!!!!!!!!
|
|
Deleted
Joined: May 7, 2024 5:59:48 GMT -5
Posts: 0
|
Post by Deleted on Sept 4, 2012 14:05:31 GMT -5
Go to Tools/Options/Save tab, and check the location of the autorecover file
Look in the file that it gives you to see if anything is there.
|
|
swamp
Community Leader
Don't be a fool. Call me!
Joined: Dec 19, 2010 16:03:22 GMT -5
Posts: 45,333
|
Post by swamp on Sept 4, 2012 14:06:17 GMT -5
looney, call your daughter.
|
|
Wisconsin Beth
Distinguished Associate
No, we don't walk away. But when we're holding on to something precious, we run.
Joined: Dec 20, 2010 11:59:36 GMT -5
Posts: 30,626
|
Post by Wisconsin Beth on Sept 4, 2012 14:06:42 GMT -5
You may be able to find it on your temp files, if you can get to them. I never can get there on my computer but maybe someone else can guide you though the steps/clicks to get there? Whats the name of the folder? Temp or??? It's hidden and I never remember how to get to it. I'm trying to remember but it's been a while since I last found it.
|
|
Deleted
Joined: May 7, 2024 5:59:48 GMT -5
Posts: 0
|
Post by Deleted on Sept 4, 2012 14:09:16 GMT -5
Excel 2003, 2007 or 2010?
|
|
MarleyKeezy78
Senior Member
Joined: Jul 22, 2011 13:20:34 GMT -5
Posts: 3,226
Location: Sittin in the mitten
|
Post by MarleyKeezy78 on Sept 4, 2012 14:18:05 GMT -5
blocked due to malware/-dwLTXAGvG_I/TdGbZxp4sKI/AAAAAAAAHbI/py03MHdMqWM/s1600/DoubleFacePalm.jpg [/img][/quote] Snort!
|
|
Wisconsin Beth
Distinguished Associate
No, we don't walk away. But when we're holding on to something precious, we run.
Joined: Dec 20, 2010 11:59:36 GMT -5
Posts: 30,626
|
Post by Wisconsin Beth on Sept 4, 2012 14:22:05 GMT -5
Ok, go to your start button. Click on "Run" (on my system is on the left column list of stuff) In the box that appears, type %temp% Click on OK. You SHOULD get a list of all files since you first logged into the computer.
If you sort it by the Date Modified column, you should be able to see the stuff you've worked on most recently.
|
|
tloonya
Junior Associate
What status?
Joined: Dec 18, 2010 16:22:13 GMT -5
Posts: 8,452
|
Post by tloonya on Sept 4, 2012 14:28:53 GMT -5
I know...I know...got to RUN and type in %TEMP% and it'll take you there...but it didn't work because I don't know which .tmp is my Excel...
|
|
tloonya
Junior Associate
What status?
Joined: Dec 18, 2010 16:22:13 GMT -5
Posts: 8,452
|
Post by tloonya on Sept 4, 2012 14:34:20 GMT -5
Go to Tools/Options/Save tab, and check the location of the autorecover file Look in the file that it gives you to see if anything is there. Where Tools/Options/Save tab???
|
|
Wisconsin Beth
Distinguished Associate
No, we don't walk away. But when we're holding on to something precious, we run.
Joined: Dec 20, 2010 11:59:36 GMT -5
Posts: 30,626
|
Post by Wisconsin Beth on Sept 4, 2012 14:35:33 GMT -5
I know...I know...got to RUN and type in %TEMP% and it'll take you there...but it didn't work because I don't know which .tmp is my Excel... You'll need to open the most likely one, which is why sorting by date modified would help.
|
|
Deleted
Joined: May 7, 2024 5:59:48 GMT -5
Posts: 0
|
Post by Deleted on Sept 4, 2012 14:36:00 GMT -5
Go to Tools/Options/Save tab, and check the location of the autorecover file Look in the file that it gives you to see if anything is there. Where Tools/Options/Save tab??? in excel. what version of excel are you using ? 2003, 2007 or 2010?
|
|
tloonya
Junior Associate
What status?
Joined: Dec 18, 2010 16:22:13 GMT -5
Posts: 8,452
|
Post by tloonya on Sept 4, 2012 14:38:40 GMT -5
2010
|
|
Deleted
Joined: May 7, 2024 5:59:48 GMT -5
Posts: 0
|
Post by Deleted on Sept 4, 2012 14:42:36 GMT -5
oh, you are golden. How to Recover Unsaved XLS Files How to Recover an Unsaved Spreadsheet in Excel Instructions Recover an Unsaved, New File 1 Open Excel and select the "File" menu. 2 Choose "Recent" and then "Recover Unsaved Workbooks." The saved drafts folder opens on your desktop. 3 Select the file you were working on and forgot to save. Select "File," and then "Save As." Recover an Unsaved, Existing File 4 Open Excel and select the workbook in which you were working. 5 Select "File," and then "Info." 6 From the list of versions, click the one labeled "when I closed without saving." 7 Click "Restore" from the business bar. This selection overwrites the previous version of the workbook to the last version autosaved. Tips & Warnings Get yourself into the habit of saving your work every couple of minutes. Never walk away from your computer without first saving your work. Never open a new program or file before saving other documents that are already open.
|
|
tloonya
Junior Associate
What status?
Joined: Dec 18, 2010 16:22:13 GMT -5
Posts: 8,452
|
Post by tloonya on Sept 4, 2012 15:05:27 GMT -5
Sorry...I am 2007...
|
|
Deleted
Joined: May 7, 2024 5:59:48 GMT -5
Posts: 0
|
Post by Deleted on Sept 4, 2012 15:10:17 GMT -5
Oh. Maybe not so golden.
how to recover the unsaved file in excel 2007 i just clicked the dont save option when i closed the window. my auto recover option is on ( for 10 minutes) please suggest
Gord Dibben Answer Gord Dibben replied on MCC Community Star
Had you previously saved this workbook or was it a new one?
If a new one, it is gone. If previously saved, you at least have the workbook without the unsaved changes.
Autorecovery saves a temp file which is available for recovery if Excel crashes with unsaved work.
If you just close out normally the temp file is deleted.
Autorecovery does not save a backup copy nor make incremental saves to the file as you work on it.
Gord
|
|
Angel!
Senior Associate
Politics Admin
Joined: Dec 20, 2010 11:44:08 GMT -5
Posts: 10,722
|
Post by Angel! on Sept 4, 2012 15:32:25 GMT -5
Click on the circle button in the upper left hand corner, then select the excel options button at the very bottom of the menu.
Click the SAVE tab on the left. Then see if the Save AutoRecover information is selected. If not you are screwed, it wasn't autosaving. Then look at where the autorecover files are set to save. I believe default is C:\Documents and Settings\UserName\Application Data\Microsoft\Excel\.
Then find that file location & look for files ending in the .xlsb extension.
However, if you opened up excel & nothing happened, there are likely no files to recover. So the above is probably a pointless exercise.
Files are only saved autorecover if there is an unexpected shutdown. If someone came along & closed the program normally & didn't save the work, there would be no recovery file. Since no recover file opened, then odds are either this happened or you don't have the autorecover selected in the options.
|
|
Opti
Community Leader
Joined: Dec 18, 2010 10:45:38 GMT -5
Posts: 39,728
Location: New Jersey
Mini-Profile Name Color: c28523
Mini-Profile Text Color: 990033
Member is Online
|
Post by Opti on Sept 4, 2012 16:18:15 GMT -5
Loony, If you never ever saved the file under a name you wanted that's at best a horrible habit. (I don't think double face palm fully expresses my thoughts BTW...) Anything Microsoft auto saves is to temp files it uses to make it easier(my guess) to buffer reads and writes once you finally decide to write the file. I always save the file to a name I like shortly after starting to create it. I can't imagine working on a file for 4 days straight and never saving it. It reminds me of over twenty years ago at college when I was working the computer room I noticed someone had typed in their entire one page program at the UNIX shell prompt. They had never hit return, must have done tab or something but I was wordless for a moment when I decided to explain how that wasn't going to work. (I really wanted to do this and walk away but my shift was just starting. )
|
|
Opti
Community Leader
Joined: Dec 18, 2010 10:45:38 GMT -5
Posts: 39,728
Location: New Jersey
Mini-Profile Name Color: c28523
Mini-Profile Text Color: 990033
Member is Online
|
Post by Opti on Sept 4, 2012 16:21:55 GMT -5
Click on the circle button in the upper right hand corner, then select the excel options button at the very bottom of the menu. Click the SAVE tab on the left. Then see if the Save AutoRecover information is selected. If not you are screwed, it wasn't autosaving. Then look at where the autorecover files are set to save. I believe default is C:\Documents and Settings\UserName\Application Data\Microsoft\Excel\. Then find that file location & look for files ending in the .xlsb extension. However, if you opened up excel & nothing happened, there are likely no files to recover. So the above is probably a pointless exercise. Files are only saved autorecover if there is an unexpected shutdown. If someone came along & closed the program normally & didn't save the work, there would be no recovery file. Since no recover file opened, then odds are either this happened or you don't have the autorecover selected in the options. This is 2007 right? Unless she bought an upgrade herself, she'll have 2003 like I do. My laptop is XP Service Pack 3.
|
|
8 Bit WWBG
Administrator
Your Money admin
Joined: Dec 19, 2010 8:57:29 GMT -5
Posts: 9,322
Today's Mood: Mega
|
Post by 8 Bit WWBG on Sept 4, 2012 16:23:56 GMT -5
Tloonya, it sounds like you bought M$ Office after all.
If you want to save, you need to buy the deluxe version. The basic version doesn't save. You have to take a picture of the screen to retain your data.
|
|