Want to highlight a helpful answer? Upvote!

Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How to find a lost file in Microsoft Office Autorecovery

Hi - This isn't really a question, though it would have been a couple of hours ago.


After saving all his files, closing them and closing all apps, my husband rebooted his Mac Pro (Lion). When it restarted, his key Excel file wasn't there. There was no trace of it in Finder, and no trace in Time Machine. A search by Date Modified or File Name didn't show the file anywhere, either. It was like it had been sucked out of the computer and the Time Machine hard drive completely.


Cheering as that thought is, there is another answer.


Microsoft Office has an Autorecovery function that saves files when, for example, there's a power failure. These files are located on the home drive, in the Library (press Option when you click "GO" in the Finder command line at the top of the screen, otherwise Library is invisible). In Library, there is a folder called Application Support. In that folder are folders for a number of applications, one of which is Microsoft. In the Microsoft folder, there is a folder called Office. In that folder are a number of folders, one of which is Office 2011 AutoRecovery. Click that, and any files saved by the autorecovery function will appear.


Hierarchically:


Finder

Go

Library

Application Support

Microsoft

Office

Office 2011 AutoRecovery


The key thing to realize here is that a file which gets saved in Autorecovery DOES NOT appear in any searches by date modified, name of file, etc. It's as if it is hidden completely after being saved. When you turn the computer back on after a power failure, the file pops up and does say something about recovery, but if you're not looking for it, it's easy to miss. As long as you have the file open and keep saving, there's no problem - it's just that when you close it, it seems to have disappeared completely!


I found this information on the Microsoft help pages under a slightly different heading:


http://http://support.microsoft.com/kb/2650066#Method3


So for what it's worth, that's the story, and I hope it saves someone the sheer panic of not being able to find a file in Office.

Mac Pro, Mac OS X (10.7.3)

Posted on Sep 8, 2012 5:35 PM

Reply
202 replies

Jul 21, 2017 4:30 PM in response to margb

Hi Folks,


I had this issue last night and I could find your path - I was stuck after 'Go'! Could not find 'Library' anywhere.


Called the lovely Apple Support Folk and the extra little trick is to search for the folder instead via Spotlight. Although a normal search won't bring it up, therefore try:


  1. Hit Command + Space bar,
  2. Type: ~/Library,
  3. Hit Return


Then follow the prompts:


Application Support

Microsoft

Office

Office 2011 AutoRecovery


Happy Searching! :-)

Jan 14, 2017 10:12 AM in response to margb

I lost an Excel file I have been working on and using for years. I had just spent a few hours making some improvements to it that I was excited about and decided to email it to myself as a backup measure. Ironically, saving and closing caused me to lose track of it - it was like it disappeared and my computer was pretending like it never happened. I cried... seriously. Then I googled "lost excel file" and this was the second URL google returned. THANK YOU!!!!

Oct 11, 2017 1:20 AM in response to margb

Hello, margb, I cannot thank you enough for this post. I was freaking out before, because I thought I had permanently lost a graduate school assignment after my computer crashed. I tried searching for possible solutions and nearly bought a data recovery application for $90, because I was that desperate. Thank goodness I found this, because I have managed to recover my file that I thought was gone for sure (I was even considering taking a day off work to start my assignment over again). Thank you so much again!

Apr 18, 2013 8:55 AM in response to margb

Just an FYI, the library (in this case the user library) is hidden by default in Lion and Mountain Lion, you accessed it correctly but that is the reason the files did not appear when you searched for them. The location of the autorecover files is changeable, if you want to make them more accessible you could locate them elsewhere.

May 17, 2013 10:20 AM in response to margb

I kept getting this error message when I was working in Word 2011 and searching for answers:

"This is not a valid file name. Try one or more of the following: Check the path to make sure it was typed correctly. Select a firle from the list of files and folders."


It started about 3 weeks ago. I was driving me bonkers. I found this posting that let me find the hieracy for the AutoRecovery files and reloacted them to Office 2011 >Office folder. I don't know how it got moved to another location (actually the file was in the trash when I found it. When I went to (Word>Preference>File Location>AutoRecovery) it showed the location of the file as being in the trash - Weird. I moved the file to Office and clicked Modify and the AutoRecovery link in Location showed the change that the file was now in Office. It seems that all is well again-at least for now.


According to some sources I found, I thought I was going to have to reload Word 2011. I did not have to go through that hassel. Thanks so much for the response given by margb that helped me solve this annoying issue.


Gwen

May 17, 2013 11:33 AM in response to Gwen Kelley

Gwen Kelley wrote:


I kept getting this error message when I was working in Word 2011 and searching for answers:

"This is not a valid file name. Try one or more of the following: Check the path to make sure it was typed correctly. Select a firle from the list of files and folders."


It started about 3 weeks ago. I was driving me bonkers. I found this posting that let me find the hieracy for the AutoRecovery files and reloacted them to Office 2011 >Office folder.

Link to the posting please.

How to find a lost file in Microsoft Office Autorecovery

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.