Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: My problem with unsaved workbooks in Excel

01 Jul 2014   #1
Franky

windows 7 32-bit
 
 
My problem with unsaved workbooks in Excel

Hello to all,

I have few problems or misunderstandings about the auto-saving/recovering workbooks in Excel 2010 that try to explain them clearly as follows:

First I create a New Microsoft Excel file And put some data into it and wait for more than 1 minute, because I changed the time of Save AutoRecover information every (from File / Options / Save / Save workbooks part) to one minute. After passing that time (more than one minute) I close that workbook without saving it, i.e, pressing don't save button. OK, now I open that file again, but, (my first oddness!):

1- The both UnsavedFiles folder (from path, File / Info / Manage Versions section / Recover Unsaved workbooks (button)) and Recover Unsaved Workbooks folder (from path, File / Recent, right hand pane) are Empty! Why?

After reopening that file I go to path File / Info / Versions. There is one writing/button next to the Manage Versions button: "Today, 5:22 PM (when I closed without saving)". If I press that button I can restore the changes which I have made but haven't saved. I restore the lost data and save that file and close it.

For the second time I open that file and put other data into it! And (as, a bad boy does such things in his routine basis!) close the file again without saving it but of course after waiting more than one minute. This is second time, that is, I've saved somethings at least one time into that file before. OK. I open the file once again and go through File / options, but:

2- again, just like "1-", those two folders are still empty! Why? I just can restore that file again like previous time.
Those two folders seem always to be empty which is very strange.
I'm sorry if I gave you a headache!


My System SpecsSystem Spec
.
01 Jul 2014   #2
Kari

Microsoft Community Contributor Award Recipient

 

You have misunderstood the concept of auto save / recovery in Microsoft Office.

The auto save works. It saves the file in a cache in intervals determined by you, and can recover the file if Excel crashes.

However, if you close Excel normally (no crash) and select Don't save, Excel logically thinks you as the user don't want to save the changes ergo it is unnecessary to save them, and empties the cache. In other words the reason that those auto save versions are no longer there is you, yourself. You have told Excel you don't want to save, Excel has no reason to keep the changes.

Kari
My System SpecsSystem Spec
02 Jul 2014   #3
Franky

windows 7 32-bit
 
 

Thanks kari.

do you mean the cache by those two folders I mentioned? If so, OK, I try to make a crash to machine and see whether what changes that crash cause to those two folders!
My System SpecsSystem Spec
.

02 Jul 2014   #4
Kari

Microsoft Community Contributor Award Recipient

 

Quote   Quote: Originally Posted by Kurdman View Post
Thanks kari.

do you mean the cache by those two folders I mentioned? If so, OK, I try to make a crash to machine and see whether what changes that crash cause to those two folders!
Please tell me that was a joke? You cannot seriously plan to crash your computer, only to see if the auto save works or not!

I admit it's your computer and you are entitled to whatever you want to but that's just plain stupid.
My System SpecsSystem Spec
Reply

 My problem with unsaved workbooks in Excel




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Problem after permanent hibernations, unsaved files
Hi there guys! I have a problem after using hibernation to "turn off" my desktop PC. It's a simple way to continue working on my projects after resuming, so I used to hibernate the machine for about month and a half... or even two months. But one day, after resuming, the PC started acting not...
General Discussion
Recover unsaved document.
Hey guys, I had a document I was working on and for one reason or another, my computer was restarted unwillingly. Anyway, once my computer had restarted and I opened MS office word 2010 I noticed the recovery panel contained my document along with several others (thankyou MS), however without...
Microsoft Office
"Unsaved Theme" Problem
Hey everyone. I have a problem with the Themes in Windows 7. There is a problem with the "Unsaved Theme" Here's the problem: I go into Themes and it shows two themes, "Unsaved Theme" and the current theme I created. Right now it is on "Unsaved Theme" so I change it to the theme I want to and...
Themes and Styles
Muktiple workbooks inExcel 2010 save as XML file
Hi all It seems not possible to save a 2010 EXCEL spreadsheet containing multiple workbooks as an XML file -- however you CAN save it as a type 2003 XMLworkbook. This works and seems to conform to the XML standard but are MS going to drop this. XML is a decent OPEN common standard -- we use...
Microsoft Office
Renaming composition to Unsaved.
Hello, Sorry for my bad english. I have a problem with my Windows 7 HP x64. Every time I select theme for exemple: Windows 7 Default theme, and click ok, it isnt staying selected, but Windows is automaticly creating that same composition but its calling it Unsaved composition. I fixed it...
Customization


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 23:23.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App