Excel 2010 autosave

I am using Excel 2010.  I thought I saved changes to an excel file, but it looks like I didn't.  I checked the Save Options and auto save every 10 minutes is checked off to the default location: C:\Users\Username\AppData\Roaming\Microsoft\Excel.
There are no files.  Any ideas on how to get this to work correctly?   Thanks.
LVL 3
fjkaykr11Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ITworksCommented:
Is it checked off or on?  If auto save is configured to be on then it will auto save documents every 10 minutes.
0
ITworksCommented:
Oh, and are you on a client-server environment?  Does the server redirect your AppData profile to a network path maybe?  

Start > Run > rsop.msc and look at the policy in effect.
0
fjkaykr11Author Commented:
@ITWorks thanks for the reply.  It is checked off.  I have no idea what I am looking for in the rsop.msc policy. My computer is Windows 7 Professional.
0
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

FaustulusCommented:
I doubt that a workbook that has never been saved will be auto-saved at all, and if it is auto-saved it shouldn't be at C:\Users\Username\AppData\Roaming\Microsoft\Excel but the default file location.
I don't know, but I guess that you need to save a workbook once before auto-save can kick in, and the location will be where you saved the workbook, usually some place like My Documents.
0
fjkaykr11Author Commented:
@Faustulus I had saved this worksheet already (my old changes are displayed).  When I added in more information, I thought I had saved it again but I don't see it.  
I checked the default folder that was listed in Excel save settings:
 C:\Users\Username\AppData\Roaming\Microsoft\Excel  and it is empty.  
This is a client server environment as @ITworks asked prior, I am just not sure where to search after I run rsop.msc.  I just want to make sure this is enabled properly and if it is stored in another location as specified in rsop.msc, where do I search.
0
FaustulusCommented:
When Excel saves a workbook automatically it replicates yourself pressing the Save button. It doesn't create a spare copy somewhere else. If your work is Auto-Saved every 10 minutes you might still lose 9 minutes' worth of work.
As for the changes that you are trying to find, I'm afraid they don't exist any more if they aren't in the workbook that you open.
0
fjkaykr11Author Commented:
@faustulus I am confused, what is the autosave recover option and autosave file path in Excel for ?  Any ideas whyk the autosave isn't working?  @ITworks mentioned if I am in a client server environment the policy may override the local settings and store the autosave in a network location, is this not the case?  I am using Windows 7 in a Network environment but dont' have any IT person available to verify the settings.  Thanks.
0
FaustulusCommented:
AutoSave presses the Save button for you at regular intervals. The file is saved under its own name at its appointed location, not some system-defined location.
Recovery saves a copy of a workbook in case of a crash of either the Excel application or the entire environment. I don't know where these copies are saved, but they will be offered the first time you open the file again after the crash. If there was no crash there are no automatically saved Recovery files.
Sorry to be the bearer of bad news.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fjkaykr11Author Commented:
ok so that feature is only for a crash that makes it clearer, so the network setting really wouldn't have helped in this case because Excel didn't crash.   It looks like Auto save isn't working, not sure why.
0
fjkaykr11Author Commented:
I am still not sure how to fix this but no new comments have been added.  thanks.
0
fjkaykr11Author Commented:
I was doing more searching and it looks like I was looking at the wrong folder.
The correct folder is:
C:\Users\shermf\Application Data\Microsoft\Excel\%folder%
within the %folder% with the correct date/time stamp there is an .xlsb file, once I clicked on the .xlsb file, the Excel file with the autosave data opens.
0
FaustulusCommented:
Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.