fixed : where are my Office 365 AutoRecovery files ?

Question :

I accidentally messed up the Office documents (Word/PowerPoint/Excel) I was working on, and I didn’t save it before, so I wanted to get the auto-saved version from the AutoRecovery-folder as I’ve done in the old days of Office 2008 and 2004.

But now I am using Office 365, and I can’t find the AutoRecovery folder anywhere… where is it ?

 

Answer :

You might have guessed : nowadays, the AutoRecovery-folder is located in an entirely different location on your Mac.

If you are running Office 2011 for Mac (whether as part of Office 365 or not) the correct path to the AutoRecovery-folder is this :

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

And if you are running Office 2016 for Mac (whether or not as part of Office 365) the correct path to the Word 15‘s AutoRecovery-folder(s) is :

~/Users/username/Library/Containers/com.microsoft.Word/Data/Library/Preferences/AutoRecovery/

for PowerPoint 15 the correct path is :

~/Users/username/Library/Containers/com.microsoft.PowerPoint/Data/Library/Preferences/AutoRecovery/

and for Excel 15 the correct path is :

~/Users/username/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/

BEWARE : it’s not straight-forward to get to this folder in recent/current versions of OSX and macOS, as the user’s Library-folder is a hidden folder. So if you want to access it, the easiest way to do so is :

– in the Finder, click on “Go” in the top menu bar

– when the pulldown menu appears, press the ALT-key on your keyboard (a.k.a. OPTION-key) and an extra option named “Library” will appear in the pulldown menu

– while holding the ALT-key, click on “Library” and your personal (hidden) Library-folder will open in the Finder

– there you can navigate further using the paths listed above to find the AutoRecovery-folder you’re looking for

That’s it.

Enjoy !

😉

NOTE # 1 :

It is advisory to also switch on the “file overwrite protection” (or “double backup”) option as it stores the previous version of the file you are working on. In Word, you turn this feature on from Word –> Preferences –> Save and then mark the “Always create a backup copy” check box. This way, whenever you click “Save”, a backup version is made of the previous/stored version before it overwrites the stored version of the file… so with it turned on, you at least have one prior version of your file.

NOTE #2 :

If you do not see the autosave file you were expecting to find in the AutoRecovery-folder, you might need a ‘show hidden files’-app to find it. Especially Excel-autosave-files tend to be hidden.

There are various ‘show hidden files’-apps :

The FREE one in the Mac App Store is Show Hidden Files: best finder but you could also use another FREE app like Hidden Files Toggle (by ZandorSmith.nl) or Funter (by Nektony.com) or HideSwitch (by CreativeCag.com)

Just beware! that you can mess up OSX or macOS entirely is you accidentally delete or alter files that are hidden in regular use !

[ a big Thank You to thekurrgan for discovering this and posting this find here ]

NOTE #3 :

it turns out that there’s a bug in Excel 2011 for Mac : even though the Autosave does save  a file with an .xlsx file extension, it’s not a true .xlsx file ! trying to open it will lead to an “Microsoft cannot open this file”-error. The solution is to change the file extension to either .xlsb (Excel binary format) or .xlb (older Excel backup format), to enable Excel to recognize the file and enable it to open.

[ a big Thank You to Paul Preston for noticing this problem and for Bryan P for posting the solution on Superuser.com and to Rich Michaels for posting his updated solution on answers.microsoft.com ]

Donate Button (MacManusNL)

Advertisements

fixed : get the embedded video from my Opendisc-enhanced audio-CD into iTunes

Question : I just got a new audio-CD that I imported into iTunes, but this CD also has extra video-content on it when you put it in your Mac (or PC). The system used for this is called Opendisc®. Though it seems impossible, is there a way to rip this video of the CD and into iTunes on my Mac ?

Answer : Yes, and you don’t even have to rip or hack for it.

1- download HideSwitch :

http://www.macupdate.com/app/mac/36771/hideswitch

2- install HideSwitch and run it – in the small window that appears, click the “Show All Files” button, now your Finder will refresh, and you will be able to see all so called ‘hidden files’ on your Mac

[ CAUTION : do NOT touch or mess with any greyed files (= normally hidden files) when you’re in “Hidden Files Viewable” mode ! …as it will very probably cause you software problems that can only be restored doing a complete system reinstall ! ]

3- put the Opendisc-enhanced audio-CD into your Mac – on your Desktop it will be visible twice : once as a regular audio-CD which has the name of the actual CD, and once as a (greyish) CD named “Opendisc”

4- when you double-click on the “Opendisc”-icon, a folder wind will open, in there go to the (greyed out) folder called “CDEXTRA”, inside that one go to the (greyed out) folder called “OPENDISC”, on to the folder called “MEDIA” – in there you will find a file called “video.mov” (yes, that’s a regular QuickTime-movie) – drag that file called “video.mov” to your Desktop

5- go back to the HideSwitch window and press the “Default” button, wait for the Finder to refresh and close HideSwitch

6- download and install Miro Video Converter (for free) either from the Mac App Store or from the developer’s website :

http://www.mirovideoconverter.com/

7- run Miro Video Converter and drag the file called “video.mov” onto the red window – select “Apple Universal” from the drop down menu and put a check mark in front of “Send to iTunes” – then click on the “Convert!” button

8- after the conversion is done, open iTunes and in the video section the converted video can be found as “video.apple” – now adjust that name to whatever you want it to be

9- to clean up you can now drag both the “video.mov” and “video.apple.mp4” files from the Desktop into the Trash and empty the trash

Done !

Enjoy !