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
Question marked as Top-ranking reply

Posted on Jul 21, 2017 4:30 PM

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! :-)

202 replies

Jan 19, 2015 9:09 PM in response to excelexcel

Hi, excelexcel, sorry I don't monitor this regularly. By any chance, did you go Computer/Macintosh HD/ Library/Application Support/Microsoft? That is a different library, one that doesn't require pressing "option" when you click on "GO" in finder. In the hierarchy, be sure to press the option key BEFORE you click "GO" in Finder, then click on the "Library" which only appears if the option key is pressed. If you have Microsoft Office on your computer, you should find the rest of the file tree. Let me know? Good luck!

Feb 1, 2015 9:39 AM in response to ewhalle1

Hi, ewhalle1,

So glad you recovered your hard work in large part. The panic part is no fun at all! Please consider a flash drive backup that you routinely update every day. In the time since the original post, just knowing that my husband's key files were backed up on both time machine and a flash drive has saved me so much stress. Good luck with your dissertations!

marg

Feb 1, 2015 8:41 PM in response to Ken Choi

Hi, Ken,


As I've said before, I'm not a Microsoft expert by any means, but I believe in the worth of search engines. That's how I found the information that I wrote up in the first place! To see if there was something that might help you, I just did a search on "what does autosave do in Microsoft Office for Mac", and got a long list of hits.


You could try the same kind of search, or alternatively go to the Microsoft Office support site, and see if you can find something helpful there. I'm sure there is a solution, especially if you went to the trouble of autosaving your documents.


Hope you are able to find them.

Mar 18, 2015 8:57 AM in response to jcmckinn

Thank you so much for posting this! This is exactly where my file was. I have had the same file mysteriously "move" 2 different times and I haven't been able to find it and have had to redo the work again. This fixed it. I also need the final for an exam and had typed out notes and potential exam questions.


Thanks again!

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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 Account.