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

Feb 12, 2014 10:16 PM in response to Sam's__dad

I'm in desperation mode. Word crashed and recovered all documents except the absolutely critical one that I need. I went through all the steps and can see hidden dirs, but can't find any .asd files and don't see the "Files created in last 7 days" anywhere. I have nothing in terms of temp files, yet autorecover is set for every 10 mins and i lost 8 hours of data. I note that it doesn't look like an autorecover folder was specified in the autosave. Any thoughts at all??

Feb 12, 2014 11:09 PM in response to talk24

Hi - that's a horrible feeling, but it may well be there somewhere.


Try going into the Finder and create a new Smart Folder. When you click this a narrow "Search" bar appears with a "+" sign. Click the "+" and select "Files Modified in" then specify the last 1 day.


If you've unhidden your files, that will bring up everything it can find, and it may be in there. (As long as you had originally saved your file, then in my experience, ou don't need to have specified an autosave location. You can in future though, which makes these files so much easier to find.)


Good luck and I hope that helps.

Mar 26, 2014 12:38 PM in response to margb

Guys, I have found the solution and it has saved my life. Let me note first that in my case, I had accidentally closed the Autorecovery file that Word automatically opened when it rebooted. I could not find the files in the Microsofy Autorecovery folder. However, I found a way that allowed me to recover all of it!


Basically, click "go" on the finder or press command+shift+G.

Then type this to access temporary documents: /private/var/folders


NB: do not erase anything from this point!!!


There are many many folders... Some of them have restricted access. It will take a while until you find one that may se suspicious to be the one! In my case, after going to the direction cited above, I then opened "kf" and then a long named folder like "hss24n112....", then a folder "T" and then "temporaryitems" and from there I saw many "Word Work Files" some of them ending in .doc but mainly in .tmp


Copy those into whatever folder you want to put them (or drag them) but do not erase anything!


Then simply drag any of those documents into word and hopefully you will find the mother**** document that scared the **** out of you. time for a little celebration and them back to work, knowing you have beat the system and that you are actually a hacker. Anyways, hope you find this useful!

May 13, 2014 9:53 PM in response to margb

**********************

VERY IMPORTANT! MIGHT HELP!


Nothing worked for me accept the following:


Open Finder -> Harddisk -> Users -> Select the Admin User Box, Most cases its in your Name eg. John -> Library -> Application Support -> Microsoft -> Office -> Office 2011 AutoRecovery


***INCASE ANY OF THE FOLDERS DO NOT SHOW THEN ENABLE SHOW HIDDEN FILES BY DOING THE FOLLOWING:


So, prior to my upgrade to OS X 10.7 all of my OS related hacks where done using third party tools such as Secrets Prefpane. However, I have decided to try and avoid third party apps as much as possible, and actually try and keep my Lion install as slim as possible. Although this article was originally written for OS X Lion, the command has been tested and proved to work in Mountain Lion and Mavericks as well

So here’s my first of what will soon be many OS X terminal commands to do what the third party apps do, without the bloat/overhead.

To enable hidden files/folders in finder windows:

  1. 1. Open Finder
  2. 2. Open the Utilities folder
  3. 3. Open a terminal window
  4. 4. Copy and paste the following line in:

defaults write com.apple.finder AppleShowAllFiles YES

  1. 5. Press return
  2. 6. Now hold ‘alt’ on the keyboard and right click on the Finder icon
  3. 7. Click on Relaunch

You should find you will now be able to see any hidden files or folders. One you are done, perform the steps above however, replace the terminal command in step 4 with:

defaults write com.apple.finder AppleShowAllFiles NO

If the above is not working for you, you may want to try switching YES/NO to TRUE/FALSE .. Beware that this is case sensitive!

defaults write com.apple.finder AppleShowAllFiles TRUE


INCASE FOLDERS ARE NOT OPENING:


Switch folder view options from tiles to grid view.


HOPE THIS HELPS


LIST OF ALL THE PROBLEMS I FACED


MIGHT SAVE YOUR LIFE


THANK YOU;)

May 17, 2014 3:06 PM in response to epsheddphoto

Hi future poster! Great that you recovered your data! It is nice to wanting to thank the original poster(s). However, most people in this thread get notifications about a new contribution in case that there is a new message. A thank you message isn't really a new contribution... Hence, my suggestion to you is to instead of posting a "thank you" message to like/thumb up the post.

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.