Tag Archives: MacOSX

fixed : where are my Office 2011 AutoRecovery files ?

Posted on by
167

UPDATE : the updated version of this post for Office 2016 / Office 365 (Word 15 / PowerPoint 15 / Excel 15) can be found here :

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 before in Office 2008 and 2004.

I forgot where to find the AutoRecovery-folder, so I used Office 2011’s build-in Help-option to get a hint. It told me I would be able to find the folder via this path :

~/Users/username/Documents/Microsoft User Data/Office 2011 AutoRecovery

But when I open that folder I have a “Office 2004 AutoRecovery” and a “Office 2008 AutoRecovery”-folder, but there’s no such folder for Office 2011…

I checked in the Office 2011 Preferences to make sure Auto-saving is switched on, and it is… so where did the folder go ? where are my auto-save documents ?

 

Answer :

You might have guessed : there’s a fault in the Office 2011 Help file. Nowadays, the AutoRecovery-folder is located in an entirely different location on your Mac. The correct path is this :

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

But there is yet another tiny hurdle to get to it : in the current version of OSX, 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 to Application Support–>Microsoft–>Office to find the “Office 2011 AutoRecovery”-folder you are looking for

That’s it.

Enjoy !

😉

Note : It is not clear if this problem is due to OSX 10.9 “Mavericks” or that it is occurring with all installations of Office 2011 for Mac. Either way, the solution is as mentioned above.

UPDATE :

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 ]

Donate Button (MacManusNL)

fixed : PowerPoint presentation too large for eMail

Posted on by
Reply

Question :

I just made a beautiful PowerPoint presentation which I want to eMail to my friend. When I tried to eMail it, that seemed to work okay at first, but a few moments later I got an error message saying that the eMail could not be sent.

How can I fix this ?

 

Answer :

eMail providers have set a limit to the attachments’ file size per eMail to prevent cluttering the eMail traffic and flooding the recipient’s eMail inbox. For most providers this limit is set to about 5MB of attached files per eMail message. Some providers have expanded this limit to 10MB, and providers like Gmail, Hotmail and Yahoo! even allow you to attach up to 25MB of files to each eMail.

But if your PowerPoint presentation is even larger than 25MB (which might easily occur if you have done your best to make it a beautiful presentation), you will probably do the recipient  a pleasure if you send a smaller file, especially if they are planning on viewing it on a mobile device. The easiest way to ‘shrink’ the size of a presentation is to convert it into a PDF-file. (a PDF-file is even more versatile than a PowerPoint-presentation, as it also can be viewed by people that don’t have PowerPoint software installed)

To convert your PowerPoint-presentation into a PDF-file, do this :

In MacOSX :

– open your presentation in PowerPoint

– then go to “File” in the upper menu bar and select “Print” from the pulldown menu that appears

– in the “Print” menu that appears, adjust everything as desired, then click on the “PDF” button (bottom left)

– in the pulldown menu that appears, choose “Mail PDF” and a new eMail message will be made for you including your Presentation as an attachment

…or you can choose “Save as PDF…” to first save the PDF-version of your presentation to your Mac so you can attach it to any eMail later on

Note : the above procedure also works in other OSX programs like Word, Excel, Pages, Numbers, Keynote, etc.

For Windows users, the general idea is similar but slightly different :

http://office.microsoft.com/en-001/powerpoint-help/save-as-pdf-HA010064992.aspx

If the standard conversion of your PowerPoint into a PDF still turns up with a PDF-file that is too large to eMail, you can adjust the conversion settings, as described here :

How to create even smaller PDFs in OSX

You might also want to try the “Reduce File Size” that is in the “File”-tab of each Office 2011 application (so in Word, PowerPoint and Excel). This option will only reduce the size of the pictures inside the document. The smallest this option can reduce to is 96ppi a.k.a. “Best for sending in e-mail”. This is an interesting option, but converting to PDF usually leads to even more file size reduction.

And if the recipient insists on getting the original PowerPoint-file, you could do as a lot of professionals do, and send your presentation trough the FREE WeTransfer service :

http://www.wetransfer.com

that’s it !

enjoy !

😉

Donate Button (MacManusNL)

test : Albert Heijn (a.k.a. iClever) Apple-imitation bluetooth keyboard

Posted on by
5

The official Apple Bluetooth keyboard looks really cool and works smoothly, but it’s expensive… a little too expensive for most purposes people say…

Of course there have been lots of alternative wireless keyboards available, but none really got the looks of a genuine Apple one (for some that is a must). That’s probably the reason why some unknown asian company has made an un-branded ‘white label’ all-plastic knock-off imitation which – at first glance – looks nearly identical to the aluminum Apple bluetooth keyboard. This imitation keyboard is available under a wide variety of brands, like the iClever-brand in most of the world, but for instance also under the dutch supermarket Albert Heijn’s own private label.

The iClever wireless keyboard can be purchased from Amazon.com, Amazon.co.uk when you want a regular QWERTY-layout, and from Amazon.de if you want a german QWERTZ-layout.

Anyway, the main question is : is it any good ?

Simple answer : Yes, but…

Let me clarify : Yes, it’s a really nice keyboard to have and to use, with an interesting price tag below € 25 (sometimes even in the € 15 region). But it comes with a few flaws, so to quickly round up the verdict :

It’s an ideal low-budget wireless secondary keyboard for use with any Apple device that has a primary keyboard built-in.

To be more specific :

it’s a great low-budget wireless keyboard for use with an AppleTV

it’s a very nice low-budget wireless keyboard for use with an iPad or iPhone (but there might be quite a few handier options, like a iPad-cover with built-in keyboard)

it’s a good low-budget secondary keyboard for use with a MacBook (Air/Pro), for instance when your MacBook is closed and connected to a bigger screen

it’s a handy, but slightly tricky keyboard for use with a Mac mini, iMac or Mac Pro (for these Macs I would advice to keep an regular USB-keyboard at hand for emergencies)

Why ?

NOTE (*) : the top-left key (the one with the open square) on this keyboard is the [HOME] key

– it doesn’t have an Escape (ESC) key, so when any program on your Mac hangs, you will not be able to Force Quit the application with this keyboard…

UPDATE (*) : to [ESC], use this key-combo : [FN] + [HOME]

so, to Force Quit, use this key-combo : [CMD] + [ALT] + [FN] + [HOME]

– it doesn’t have an Eject key for the DVD/CD-drive, so when this is your only keyboard, you will not be able to get any CD or DVD out of your Mac easily… you will need to do the annoying drag-to-the-trash move using your mouse each and every time…

UPDATE (*) : to Eject, use this key (not a key-combo) : [F5]

– it doesn’t have any option to set the (energy saving) auto-disconnect function to a longer interval… which means that when your Mac also goes into (energy saving) sleep mode, the  keyboard has a lot of problems waking your Mac… (e.g. you will need to press any button for a prolonged time, but doing so also makes your Mac see that as input for any application that was still open… you might mess up your open Word-document with an enormous line of spaces in doing so…)

UPDATE (*) : to Wake From Sleep, use this key (not a key combo) : [HOME]

– the keyboard is often recognized too late when starting up your Mac, so you can’t use it to type your password during login, so you can’t start using your Mac… this is possibly only a problem for older Macs and/or older versions of MacOSX, but still…

I have tested this keyboard with Apple devices only, so I can’t tell about the compatibility with other devices, but I would think it will be similar : good to great for use with smartphones and tablets running Android and Windows Mobile, but rather troublesome for use with a Windows-PC…

😉

(*) special thanks to Arjan de Boer for these not-so-obvious, but very useful key-combos

fixed : changing the name of a Time Machine backup .sparsebundle-file

Posted on by
2

Question :

I have transported my user account from my old Mac to my new Mac (using the Migration Assistant application) some weeks ago. Yesterday, I happend to click on the Data-drive from my TimeCapsule in the Finder, and I noticed that the TimeMachine backup-file (.sparsebundle-file) is still named after my old Mac… the name hasn’t changed to the new Mac’s name…

I find this utterly confusing. Is there something I can do to change the name of the .sparsebundle-file ?

 

Answer :

Yes there is, but it appears not all versions of the TimeMachine software are happy with changing the name of the .sparsebundle-file by the user.

So if you want to change the name of a TimeMachine backup-file (.sparsebundle-file) but wish to minimize the risk of corrupting your entire TimeMachine backup-file (one thus loosing all your data), follow this procedure :

1- make sure you are operating your Mac from a user account with administrator rights

2- go to Apple –> System Preferences –> Sharing

3- there, change the “Computer Name” to a name that identifies you new Mac (and the .sparsebundle-file)

4- then, go to the TimeMachine-icon in the Finder’s top menu bar and select “Back Up Now” from the pulldown menu

5- wait for the TimeMachine backup has finished (this might take longer than normal), and check to see if the .sparsebundle-file has been renamed (go to your TimeMachine backup drive using the Finder to do so)

The above will probably be sufficient if you are running MacOSX 10.7 “Lion”, OSX 10.8 “Mountain Lion” or OSX 10.9 “Mavericks”, and if it works, it’s the preferred way for changing the name of the .sparsebundle -file, as it minimises the risk on corrupting your backups. So, always try the above procedure first !

If you are running MacOSX 10.6 “Snow Leopard” or earlier (probably even Mac OSX 10.4 “Tiger” and even PowerPC Macs with G4 and G5 processors that can run the Time Machine software), and the above procedure didn’t change the name of the .sparsebundle-file, try this :

– duplicate your .sparsebundle-file to another harddisk, or select a new backup harddisk to make an entirely new TimeMachine backup to  (to make sure you have a backup in case you accidentally mess up ; if your sparse bundle-file is your one-and-only and irreplaceable backup, make sure you do this !)

– make sure the .sparsebundle-file is operating correctly by testing it using the “Enter TimeMachine”-option from the pulldown menu that appears when clicking on the TimeMachine-icon in the Finder’s menu bar

– make sure you are logged in as a user with Administrator rights

– click on the TimeMachine-icon in the Finder’s top menu bar and select “Back Up Now”

– after the backup has finished, go to your (primary) TimeMachine-drive in the Finder, click on the .sparsebundle-file and change it’s name

– then, go to the TimeMachine Preferences (either through the System Preferences or through the pulldown menu from the TimeMachine-icon in the top bar of the Finder)

– there, switch off TimeMachine and exit the System Preferences

– then, open the TimeMachine Preferences (within the System Preferences) again, and switch TimeMachine back on, then exit the System Peferences

– then, go to your (primary) TimeMachine-drive in the Finder again, and check if the name of the .sparsebundle-file has changed

– if the name has changed, check if the TimeMachine-backup works (try to access it by clicking “Enter Time Machine” from the pulldown menu that appears under the TimeMachine-icon in the Finder’s top menu bar), if that works, that’s it, you’re done !

– if somewhere along the procedure, something didn’t work as expected, restart your Mac and try again

– if it name change still won’t stick after several tries, make sure the “Computer Name” of your Mac is named exactly as you like in the Network Preferences (within the System Preferences) and then create an entirely new TimeMachine-backup : add a new drive for TimeMachine-backups (or remove the existing drive and then add the same one again) in the Time Machine Preferences (within the System Preferences), then click “Back Up Now” from the pulldown menu when you select the TimeMachine-icon in the Finder’s top menu bar… and wait…

That should be it.

Enjoy !

😉

Note : the .sparsebundle-file extension might not be visible ; you can turn it on (or off) in the file’s “Get Info”-window (accessible when right-clicking on the file’s icon in the Finder)

Donate Button (MacManusNL)

fixed : remove icon from behind the Dock

Posted on by
Reply

Question :

I somehow managed to move an icon to the outer corner of the Desktop in such a way that there’s no way to select it and move it to another location (or trash it). The document icon even got placed behind the Dock, so whenever I try to select the icon, the Dock is in front of it, and I am selecting or activating something in the Dock…

How can I fix this ?

 

Answer :

If there’s a document icon (or app icon) on your Desktop that you can’t select to use or move the document (or app), try this :

– open the Finder

– in the Finder window that opens, select your Desktop, then select the file (or app)

– now move it to another location on your Mac ; to another folder or to a new folder

– then, when you go back to your Desktop, the file will be in folder you’ve just put it in

…and if you wish, you can even drag & drop it back onto any location on the Desktop.

That’s it !

Enjoy !

Donate Button (MacManusNL)

 

fixed : move opened Preview-document from outer corner of Desktop

Posted on by
Reply

Question :

I somehow managed to move an open Preview document to the outer corner of the Desktop in such a way that there’s no part of Preview’s document window in sight that can be clicked and dragged. So, there’s no way to drag the open document onto the center of the Desktop…

And closing the document and opening it isn’t an option either, since nove of the red/yellow/green window buttons are in sight either…

How can I fix this ?

 

Answer :

Here’s what to do :

– click and hold the Preview app icon in the Dock

– in the pop-up menu that opens, click on “Show All Wondows”

– in the view that opens, select the troublesome document

…now the document will open in the centre of the Desktop, and you can drag it or close it.

That’s it !

Enjoy !

Donate Button (MacManusNL)

fixed : hashtags making text unreadable in Excel

Posted on by
Reply

Question :

Somebody sent me an Excel spreadsheet in which some of the data is unreadable since it has been replaced by text consisting of hashtag signs only…

I’ve seen this happening before, and the remedy used to be just to broaden the column, since all number that are too large to fit their cell width are automatically made unreadable…

However, in this case, if I broaden the column width, some of the hashtag text will turned into readable numbers, but other hashtag text will remain, no matter how wide I make the column…

What is wrong ?

And how can I fix this ?

 

Answer :

This seems to be a problem with Excel for Windows files that are opened in Excel for Mac (possibly more specifically with data copied or converted from another application into Excel on a Windows-PC). So PC-users will not be warned on forehand that their Excel output is not suited for use on Macs…

Fixing it turns out to be rather simple (but annoying) :

• open the file in Excel for Mac

• select the cells that are effected (or preferably even the entire column), then go to “Format” in the top menu bar

• from the dropdown-menu that appears, select “Cells…” and a window entitled “Format Cells” will open

• make sure the “Number”-tab is selected and make sure that you select “Number” or “General” from the list (make sure that it is something else than what was previously selected ; anything seems to be okay, as long as it is not “Accounting”)

• no return to your spreadsheet to check if the hashtag texts have disappeared (if not : try again)

That’s it !

Enjoy !

😉

Donate Button (MacManusNL)