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)