Excel 2011 Mac auto-recover file lost

Yesterday morning my colleagues Excel 2011 (on Mac OSX 10.8) crashed. He reopened Excel and was asked if he wanted to recover the previous document. Yes, he said and then got a document named previousfilename(version 1). To be certain that this document was saved he continously saved the (recovered) document manually during the day and by the end of the day he saved it finally and went home.

Today there is NO trace of the document whatsoever. We have looked in original location, trash, userfolder/Microsoft userdata/Office 2011 AutoRecovery etcetera and there is no document except for the original unedited version. Spotlight doesn't find it either.

Since we have a running Time Machine backup we have lots of backups from yesterday but the same locations are also empty.

This is a freshly installed product. If this behaviour is expected Excel then having no auto-recover function at all would actually be better. I hope someone out there might help out. Manually saving a document SHOULD leave a trace somewhere in the filesystem?

Solution 1:

Finally we found the file in the folder:

~/Library/Application Support/Microsoft/Office/Office 2011 AutoRecovery

As the ~/Library folder is a hidden folder since OS X 10.7 and not by default searched by Spotlight it's incredibly stupid that this folder is auto-suggested when saving a recovered file.

Also since there IS a folder with the same name under Documents/Microsoft userdata/ that is empty this was hard to find!

To go to this folder, open Finder and in the menu click Go » Go to Folder… or press ⇧⌘G. Then, paste the path from above.

Or, to make the ~/Library folder always visible, open Terminal.app from /Applications/Utilities and enter:

chflags nohidden ~/Library