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 :

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 : where did the onscreen virtual keyboard go ?

Question :

For years, I used to start  the onscreen keyboard whenever I wanted to type a character on my Mac that I didn’t know the key-combo for by heart…

Now I’m on OSX 10.11 El_Capitan and I don’t see the icon in the menu bar top right… and I can’t find the option to switch it on either…

What should I do ?

 

Answer :

What you call ‘onscreen keyboard’ is officially called the ‘virtual keyboard’ ; it’s a very handy option in OSX as you mentioned.

For some reason, after upgrading to OSX 10.11 El_Capitan, your preset for quick access to the virtual keyboard is lost… and switching it back on is hidden in some cryptic text in the Preferences :

  • in the Finder, go to Apple [top left] –> System Preferences –> Keyboard
  • in the window that opens, under the Keyboard-tab, put a check-mark at “Show Keyboard, Emoji & Symbol Viewers in menu bar”
  • then close the System Preferences window
  • now, in the Finder, top right, click on the flag-icon and select “Show Keyboard Viewer”
  • then, the virtual keyboard will appear onscreen and you can use it as you’re used to…

that’s it !

enjoy 😉

Donate Button (MacManusNL)

fixed : why am I typing a TM-sign instead of a Euro-sign ?

Question :

Today, I had to type some text that included some financial figures, but for some reason I got a TM-sign on screen every time I typed the Euro-sign by pressing the key-combo [ALT]+[2].

I’ve never had this before.

What is wrong ?

 

Answer :

How you got this problem is unclear, but the solution is simple.

Have a look at the top menu bar (of the Finder), is there a US-flag next to the current time ?

If so, your keyboard is set to US-layout and in US-keyboardlayout the [ALT]+[2] key-combo will give the TM-sign (Trademark-sign) on screen.

To change that, do this :

  • click on the US-flag in the top menu bar (of the Finder)
  • in the pulldown menu, click on “Open Keyboard Preferences…”
  • in the window that opens, make sure the “Input sources”-tab is selected, then click on de + (Plus-sign) bottom left
  • from the list in the pulldown window that opens, choose “British” (UK-flag)
  • then click “Add”
  • back in the previous window, click on “(UK-flag) British” at the left to select it
  • then close the Preferences window by clicking the red button top left
  • then in the top menu bar (of the Finder) make sure there is a UK-flag
  • if there still is a US-flag, click on it and select the UK-flag from the pulldown menu

…then try typing the [ALT]+[2] key-combo in a text and see if it works

…that’s it ! enjoy 😉

Donate Button (MacManusNL)

fixed : animated GIFs not playing in Preview.app

Question :

For my work I regularly get animated-GIF for online advertising campaigns send to me offline. As it turns out I can only view them in the Finder’s preview, but when I double-click on them, they open in Preview.app as a static picture…

What can I do ?

 

Answer :

As any .gif-file is considered as a picture by OSX, both static and animated GIFs will be opened in Preview.app by default. Too bad, but Preview.app can only display static pictures, no movies, nor dynamic pictures…

The solution is simple ; just make OSX by default open all .gif-files in an application that can handle animations, like your web browser.

to do so :

  • locate and select any of your animated .gif-files in the Finder
  • then press the [cmd]+[i] key-combo on your keyboard (a.k.a. “get info”)
  • in the info-window that opens, scroll down to “Open with:”
  • make sure the triangular arrow in front of “Open with:” is pointing down
  • if the triangular arrow is pointing to the right, click on it
  • just below “Open with:” you will see “Preview (default)”
  • click on that, and change it to “Safari” (or any other application that can handle animated GIFs, if you don’t see the application you’re looking for listed, select “Other…” and select the one you prefer from you Applications folder)
  • then, don’t forget to click on the “Change All…”-button also

…that’s it, from now on, any .gif-file on your Mac will be opened in Safari (or your chosen alternative) by default, and you will see all animated-GIFs opened as animations when you lick on them.

enjoy !

😉

Donate Button (MacManusNL)

fixed : use unsupported scanner in OSX 10.11 El_Capitan

Question :

I have a Canon CanoScan LiDE 20 that used to work perfectly in MacOSX 10.6 Snow Leopard. But now I’ve bought a new Mac which runs OSX 10.11 El_Capitan, I can’t seem to install it, since Canon doesn’t update the drivers anymore.

What can I do ?

Answer :

In OSX 10.7 Lion, 10.8 Mountain Lion, 10.9 Mavericks, 10.10 Yosemite and 10.11 El_Capitan, any TWAIN-supporting scanner can be used without any additional software.

A list of supported scanners for OSX 10.9 Mavericks can be found here.

Here’s a quick step-by-step instruction :

– connect your scanner directly to your Mac using a USB-cable

– open the System Preferences

– then click on “Print & Scan”

– then, just below in the list of printers on the left, click on the “+”-sign

– that will bring up the “Add”-window, which enables you to add a new printer or scanner

– if your scanner is TWAIN-supporting, it will show up there, and you just need to select it and click on the “Add”-button

– then it will be listed in the previous (“Print & Scan”) System Preferences window, and if you select it (and you put a piece of paper or a photo in the scanner), a Scanning Preview window will show up, allowing you to scan your document to file or eMail or something else…

but…

…for some printers, like the Canon CanoScan LiDE 20 and LiDE 30, the TWAIN-drivers are not included in OSX. In that case, you will need to install some generic (FREE) TWAIN-drivers :

IMPORTANT : do not forget to read this entire post, even all the notes at the bottom ! e.g. if you have an old CanoScan scanner, you might have to reinstall TWAINbridge.app also !

– for OSX 10.11 El_Capitan, download and install these files (in this same order) and restart you Mac after doing so, then your scanner will also show up in the “Print & Scan” System Preferences :

LibUSB for OSX 10.11

SANE Backends for OSX 10.11

SANE Preference Pane for OSX 10.11

TWAIN SANE Interface for OSX 10.11

for OSX 10.10 Yosemite, download and install these files (in this same order) and restart you Mac after doing so, then your scanner will also show up in the “Print & Scan” System Preferences :

libusb.pkg.tar.gz

sane-backends.pkg.tar.gz

SANE-Preference-Pane.pkg.tar.gz

TWAIN-SANE-Interface.pkg.tar.gz

– for OSX 10.9 Mavericks, download and install these files (in this same order) and restart your Mac after doing so, then your scanner will also show up in the “Print & Scan” System Preferences :

libusb.pkg.tar.gz

sane-backends.pkg.tar.gz

SANE-Preference-Pane.pkg.tar.gz

TWAIN-SANE-Interface.pkg.tar.gz

– for OSX 10.8 Mountain Lion, download and install these files (in this same order) and restart your Mac after doing so, then your scanner will also show up in the “Print & Scan” System Preferences :

libusb.pkg.tar.gz

sane-backends.pkg.tar.gz

SANE-Preference-Pane.pkg.tar.gz

TWAIN-SANE-Interface.pkg.tar.gz

– for MacOSX 10.7 Lion, download and install these files (in this same order) and restart your Mac after doing so, then your scanner will also show up in the “Print & Scan” System Preferences :

libusb.pkg.tar.gz

sane-backends.pkg.tar.gz

SANE-Preference-Pane.pkg.tar.gz

TWAIN-SANE-Interface.pkg.tar.gz

– if these files do not turn into regular .pkg-files when you click on them, you need unTAR-software like this :

The Unarchiver

– if you get an error-message telling you you can’t install this software (these drivers) since the are not from Apple-appoved developers, you need to :

– open the System Preferences

– then click on “Security & Privacy”

– then make sure the “General”-tab is selected

– click the padlock in the lower left corner and provide an Administrator name & password to unlock the padlock

– then at “Allow applications downloaded from:” select “Anywhere”

– and exit the System Preferences to make this setting stick

Note #1 :

TWAIN-supporting drivers (like SANE and the ones that come with OSX) will enable you to directly scan from within various applications like Photoshop, MS Word, GraphicConverter, OmniPage and OSX’s built-in Image Capture. [ please also read Note #7 and #8 for more tips on this ! ]

Alex Scheider has written a special SANE scanner app for OSX 10.7 and newer, you can download it here. A screenshot can be found here[haven’t tested it, so feedback on this is welcome]

Note #2 :

when using the SANE drivers, you will probably not be able to use the ‘one click’-buttons that are on the scanner itself…

Note #3 :

if your scanner lets you scan the first time, but after shut-down and restart scanning seems impossible because OSX can’t find the scanner, just plug-out the scanner’s USB-cable and plug it back in and everything should work again…

Note #4 :

if the “Scan”-button remains grayed-out, make sure that you have selected an area to scan… (put differently : if “Selection:” is set to “Off”, you will need to select an area to scan before the “Scan”-button will be ready to use…)

Note #5 :

if you get a distorted scan when scanning in landscape view (or any other rotated view), just scan normally in portrait view and rotate the scanned image afterwards (in Preview app or another image editing program, like Photoshop or Graphic Converter)

Note #6 :

if you are not able to scan as a JPEG (.jpg-flie), just scan as a TIFF (.tif-file) and convert the scanned image afterwards (in Preview app or another image editing program, like Photoshop or Graphic Converter)

Note #7 :

if your scanner doesn’t show up in Image Capture (especially in OSX 10.9 Mavericks), use this workaround :

go to System Prefecences –> Printers & Scanners –> [your scanner] –> Scan –> Open Scanner

Note #8 :

if your scanner doesn’t show up in Photoshop (especially in OSX 10.9 Mavericks), try this workaround :

go to Applications –> Adobe Photoshop CS# –> Adobe Photoshop CS# –> type “CMD” + “i” key-combo (on your keyboard) –> (in the Get Info window) select “Open in 32 bit mode” and exit Get Info

then open Adobe Photoshop (CS#-version) –> File –> Import –> SANE

Note #9 :

another option that might just work to get SANE drivers to connect with ImageCapture and Photoshop (especially if you have an older CANON scanner) is (re)installing the TWAINbrigde.app that Jan Egil has ready for download on his website.

for now, there is no version of TWAINbridge.app that runs in OSX 10.11 El_Capitan, the alternative seems to be to use the old CanoScan Toolbox 5.0 software that can be found on the Canon website or here

Credits :

Matias Ellert and the Open Source developers of the SANE project

…and a special thanks to Mónica, Jorge Blasio, torrealta, dencho, BobD and Jan Egil for Note #7, #8 and #9 ! [see comments below]

If you encounter any problems with these SANE drivers for OSX, try contacting Mattias Ellert directly as indicated here.

If you want to un-install the TWAIN SANE drivers, either use an un-installer application like AppCleaner or follow the instructions for manual un-install as outlined in Mattias Ellert’s FAQ (last question & answer).

Donate Button (MacManusNL)

fixed : get usable (.tif or .jpg) pictures out of a PowerPoint-presentation

Question :

My colleague sent me a PowerPoint-presentation with pictures in it that I want to use in my own Keynote-presentation. But, whenever I select a picture in the PowerPoint-presentation and drag-&-drop it onto my Desktop (as I usually do in OSX to get a picture out of a website or alike), I get a file named “Picture Clipping.pictClipping”. When I double-click on that, I get a Finder window with the correct preview and a line of info saying “Clipping contents: TIFF image”. But I can’t import that .pictClipping file into my Keynote-presentation as a picture. Neither can I find any way to get the TIFF-image out of the .pictClipping-file.

What can I do ?

 

Answer :

You’ve stumbled upon a hard-to-tackle problem with PowerPoint-presentations.

The solutions is rather simple, but takes a some effort. You can choose to either export  only one picture, or export all pictures from the PowerPoint-presentation :

If you only need one picture :

1- make sure you have GraphicConverter installed (if you don’t have it, you can download it from the LemkeSoft.de website for FREE and use it in “try it”-mode)

2- open your PowerPoint-presentation and drag&drop the picture you need onto the Desktop ; it will appear as a file named “Picture Clipping.pictClipping”

3- right-click on the “Picture Clipping.pictClipping”-icon and select “Open with…” from the pulldown menu that appears, then select “Other…” and select GraphicConverter 9 from the list that appears

4- GraphicConverter will now display the picture ; select “File” from the top menu bar, and “Save As…” from the pulldown menu that appears

5- in the window that opens, select select the destination folder and at “File Format:” choose JPEG/JFIF, PNG or TIFF and click the “Save”-button

6- then in the Finder, go to the destination folder and drag&drop the picture into your Keynote-presentation

…that’s it 😉

If you need multiple (or even all) pictures  :

1- make sure you have GraphicConverter installed (if you don’t have it, you can download it from the LemkeSoft.de website for FREE and use it in “try it”-mode)

2- right-click on the PowerPoint-presentation’s icon and click on “Duplicate” from the pulldown list that appears ; if your original was named “presentation.ppt” the duplicate will be named “presentation copy.ppt”

3- select the icon of the “presentation copy”-file and change the .ppt or .pptx file extension into .dat (when asked “Are you sure… ?”, click on the “Use .dat”-button)

4- now, right-click on the “presentation copy.dat”-file’s icon and click on “Open With” in the pulldown list that appears, then select “GraphicConverter” and click on it

5- in GraphicConverter, you will now see only the first picture from the PowerPoint-presentation, but in the bottom bar, you will see “Page: 1 of X” (in which X is the total number of pictures), there you can scroll through all pictures ; then, from the “File”-menu, select “Convert & Modify”

6- in the window that opens, you will see 3 columns : in the left column, make sure that “Function: Convert” is selected, and “Destination Format:” is set to JPEG/JFIF, PNG or TIFF

7- in the middle column, you will see the “From:”-button and the file named “presentation copy.dat” (with the first picture as it’s icon) ; in the right column you will see the “To:”-button ; there you should select your desired destination folder

8- then, click on the “Go”-button at the bottom of the left column (and all pictures will be exported the way you have asked)

9- do not forget to drag the “presentation copy.dat”-file to the Trash (and empty the Trash)

10- in the Finder, you can now open the destination folder and drag&drop the picture(s) you need into your Keynote-presentation

…that’s it – enjoy !

Donate Button (MacManusNL)