Tag Archives: Mac

tip : get the latest versions of Word, PowerPoint and Excel for FREE, legally

Posted on by
Reply

If you are looking for a FREE (and legal) version of the latest version of MS Office, you just might be in luck :

Microsoft is offering the newest version of MS Office for FREE to students and staff of schools and universities that have licensed MS Office.

This program has run in the US since 2013 under the moniker “Student Advantage”, and is now available in the Netherlands also.

What you get is a FREE one year license to Microsoft’s online cloud service “Office 365”, in the “Pro Plus”-version, including FREE downloads of the latest versions of Office to be installed on maximum 5 Macs or PCs and on maximum 5 Android or iOS devices (like iPhones and iPads).

These latest versions are Office 2011 for Mac and Office 2013 for Windows, both including Word, PowerPoint, Excel, Outlook, OneNote, Skype and OneDrive (Microsoft’s cloud-drive formerly known as SkyDrive).

In the Netherlands, these FREE versions are available for two specific groups :

1- (parents of) students of the primary schools [“basisschoolleerlingen” in Dutch] https://www.surfspot.nl/officeleerling

2- students of (some) higher education [“Hogescholen en Universiteiten” in Dutch] https://www.surfspot.nl/officestudent

The procedure to get this (nearly) FREE software, is quite complex, but it’s well worth the hassle :

– first you need an account at Surfspot.nl (the website for educational discounts)

– then, you need to ‘buy’ the FREE version of Office 365 Pro Plus

– with that, you’ll get a voucher (which might take several days due to popular demand)

– using that voucher, you can activate Office 365 at Microsoft, and you will get FREE download-links to the latest versions of Word, PowerPoint, Excel, Outlook, OneNote, Skype, OneDrive, etc.

–  those apps you can install on maximum 5 Macs or PCs and 5 iOS or Android devices

 

…as mentioned : it’s a hassle, but it’s well worth it !

Enjoy !

😉

Donate Button (MacManusNL)

fixed : can’t remove floating promo-video from sight on Amazon

Posted on by
Reply

Question :

Every time I am browsing Amazon, whenever I look at a product page that has a product’s promo-video on it, the video will open automatically in a separate ‘floating’ window and start playing. However, there’s no button to close the window, and even though I am able to drag the video window, I can’t move it outside of the visible part of my browser (Safari). As a consequence, I’m not able to have a useful look at the product page, as the video-window is blocking off a huge part of the screen…

This is getting extremely irritating. What can I do ?

 

Answer :

This is a problem that occurs when using Safari with the AlterVideo plugin enabled when visiting video-featuring pages on the Amazon website, but it might also occur in other cases with different browsers, different video-plugins and different websites.

The way to fix this is rather simple :

– in Safari, click on “Safari” in the top menu bar

– in the drop down-menu that opens, click on “Preferences…”

– in the Preferences window that opens, click on the ‘blue puzzle piece’ tab entitled “Extensions”

– there, click on “AlterVideo” in the list on the left

– then, make sure there is NO check-mark in front of both “AutoPlay (Only for First Video on Page)” and the “Aggressive Detection (You may see a ‘floating’ video player)”

– after that, just close the Preferences-window by clicking on the red bullet top left

…now, try visiting Amazon again and everything should work properly

That’s it !

enjoy !

😉

Donate Button (MacManusNL)

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)

fixed : photo delete-button greyed out on iPad

Posted on by
2

Question :

On my iPad, I want to free up some memory space by deleting some old photos, but when I go into the Photos-app, and select the photos I want to delete, the Delete-button is greyed out. At first I thought it might have something to do with restrictions I had set on my iPad, but I couldn’t find any restriction option regarding the deleting of of photos.

When I investigated a little further, it turns out that the Delete-button is available for my newest photos, but not for the older photos… that’s where things get confusing…

How can I make the Delete-option available for all photos ?

 

Answer :

The exact cause of your problem is not known, but the solution turns out to have something to do with photos that are supposed to be kept in-sync with your Mac (or PC).

The solution is the following :

– connect your iPad (or iPhone) to your Mac (or Windows-PC) using the USB-cable

[note : the computer you connect to should be the one that you have set as the primary computer to connect to when you originally set up your iPad/iPhone from iTunes on MacOSX or Windows]

– on your Mac or PC, open iTunes and go to the iPad/iPhone’s settings and click on the “Photos” tab

– if you’re on a Mac, make sure that there is NO checkmark at “sync to folder” or “sync to iPhoto”

– if you’re on a Windows-PC, make sure there is NO checkmark at “sync to folder”

– wait for the iTunes syncing proces to finish, then disconnect your iPad/iPhone

– when you open the Photos-app on your iPad/iPhone now, you will see that all photos now have the Delete-button available

That’s it !

Good Luck !

Enjoy !

😉

Donate Button (MacManusNL)

fixed : block senders of incoming spam eMails

Posted on by
Reply

Question :

I keep getting a lot of spam-eMail lately, most of the time from the same eMail-address.

Is there anything I can do to stop this ?

 

Answer :

The extend to which you can fix this, depends on the options given by your eMail-host, but bottom line it all comes down to configuring a filter.

– open Safari (or any other browser of your choice)

– go to your eMail-host’s internet page and login using your name/eMail and password

– go to the Preferences-menu and configure a filter there that checks all incoming eMails on the criteria you configure (e.g. the sender’s eMail-address) and sends all filtered-out eMails to the trash straight away (there might be a “block sender” option, but that’s not always the case)

If you manage to set a filter as outlined above, you will not get those annoying eMails on your Mac, nor on your iPad, neither on your iPhone.

Just make sure your filter doesn’t filter too broadly, as that would even ‘desired’ eMails will get placed in the trash without ever getting into your mailbox…

If it’s not possible to set the filter in your eMail-host’s server, you will have to set a filter on any eMail-app you use on every device (so on your Mac, your iPad, your iPhone, etc.).

Setting an eMail-filter on your Mac should be done like this :

– open Apple Mail.app and select the spam eMail in your inbox

– open Mail Preferences, click on the tab “Rules”, and click “New Rule”

– that will set a new filtering-rule, which has the spammer’s eMail address already in it

– additionally configure the action that all eMail of that sender should go straight to the trash [you can include multiple spammers or senders directly or at a later time, and sometimes it is even more effective to filter based on a specific (partial) sentence from the ‘Subject Line’ or ‘Body Text’]

If you think configuring filters is too complicated, you can also decide to keep on tagging unwanted (spam) eMails as ‘Junk’. Since the Junk-mailfilter teaches itself progressively, in due time all similar eMails will be automatically filtered out and placed in the ‘Junk’-mailbox.

Good Luck !

Enjoy !

😉

Donate Button (MacManusNL)

fixed : need to reinstall an app from the Mac AppStore

Posted on by
Reply

Question :

I used to use Microsoft’s SkyDrive without any problems in recent months. Recently Microsoft has changed the name of the app and the service to OneDrive, so I have ‘upgraded’ the app from the Mac AppStore, and it has run okay, but with various connection problems (maybe because I renamed the SkyDrive folder to the new OneDrive folder, so I didn’t have to move or duplicate files and pictures).

But that’s least of my worries. When I try to startup the OneDrive app now, I get an error message, indicating that I need to reinstall the OneDrive app. As this app is downloaded from the Mac AppStore, I looked up OneDrive in there, and it indicated “INSTALLED”, but there’s no option to reinstall…

How do I reinstall this app ?

Answer :

The solution is rather simple, but you might not consider it ‘obvious’ or ‘well documented’ in OSX :

– open the “Applications Folder”

– find the corrupted app you need to reinstall and drag it to the Trash

– open the “(Mac) App Store”-app, and find the app you need to reinstall

– when you’ve found it, you will see that it now indicates “INSTALL”, so just (re)install as usual

…that’s it

Enjoy !

Donate Button (MacManusNL)