fixed : iCloud syc error – Desktop files on Mac have ‘cloud exclamation mark’-icon

Question :
I was trying to access some files I have created on my Mac from my iPad, but the files that are in folder XYZ on my Mac’s Desktop are different from the ones that I can see in that same Folder XYZ when I access it from the Files.app on my iPad. Some files in Folder XYZ are the same and some are not… closing/quitting the Files.app on my iPad and reopening it doesn’t help… And when I look on my Mac, the files that are invisible on my iPad turn out to have a ‘cloud with an exclamationmark’-icon next to them on my Mac… I’ve also checked on my iPhone, and there I get to see the exact same content of Folder XYZ as on my iPad, but not the ones that are on my Mac…

This appears to be an ICloud syncing problem, but how do I fix it ?

Answer :
Yes, this is a syncing problem that iCloud sometimes runs into…
since there is no forced sync or manual sync option, this is how to fix it :
1- make sure that your Mac, your iPad and your iPhone all run the newest version of their OS (macOS, iPadOS, iOS)
2- make sure that your Mac, your iPad and your iPhone are all connected to a stable internet connection (either over Wifi or Ethernet)
3- make sure that you are logged in on iCloud with exactly the same account on all devices (Mac, iPad, iPhone)
4- if all the above is in place, restart your Mac without remembering open windows (to increase you chances on fixing this iCloud syncing problem, restart your iPad and iPhone as well)
5- wait for your Mac to restart/reboot entirely before doing anything else on it
6- wait for iCloud to sync back and forth amoung your Mac, iPad and iPhone (depending on the amount of files you have in your iCloud folders and your internet speed this may take up to 10 minutes or even longer)

That’s it !
…in 99% of the cases, this simple solution will fix your iCloud syncing problem
enjoy πŸ˜‰

fixed : calculate the number of days between 2 dates

Question :

I want to integrate a formula in my spreadsheet (in Excel or Numbers) that calculates the number of days between 2 dates that I have in other cells on the spreadsheet.

How do I do that ?

Answer :

there are 2 formulas available to do this, choose the one that works best for you in Excel or Numbers :

formula =DUR2DAYS(enddatestartdate)+1

or

formula =DATEDIF(startdate, enddate, β€œD”)+1

NOTE : the “+1” in both these formulas is only needed if you want the number of days including both startdate and enddate !

That’s it !

enjoy πŸ˜‰

fixed : can’t edit cells in Numbers

Question :

I made an extensive table in Numbers yesterday and saved when I was ready for the day. Today I want to work on it again, and it opens without a problem, but I can’t edit any cells… I can’t click in any cell, I can’t type anything inside it and the 1-2-3 numbering of the rows and the A-B-C ‘numbering’ of the columns doesn’t appear either…

The only thing I can edit are three cells at the top of the page…

What is wrong ?

 

Answer :

The solution might be rather simple : Β probably, you have accidentally entered the Printing Preview mode.

You can see you are in Printing Preview mode when there are 2 buttons visible at the bottom the Editing pane on the right : “Done” and “Print…”

If so, just click on the “Done”-button to leave the Printing Preview mode and go back to the main Editing screen.

That’s it !

enjoy πŸ˜‰

tip : quickly typ numbers and non-alphanumeric signs on iPad

TIP :

there is a quick way to typ numbers (and other SHIFT-accessable digits) on iPad in iOS12 and iPadOS :

when the on-screen keyboard is visible, just swipe-down (pull-down) on the on-screen key to get it’s SHIFT-version

e.g. : if you swipe down the 3-key, you will typ the #-sign, and if you swipe-down the 7-key, you will typ the &-sign

enjoy πŸ˜‰

 

fixed : PowerPoint presentation too large for eMail

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)

tip : get Keynote, Pages & Numbers for FREE with OSX 10.9 Mavericks

Question :

I heard that you can get the new versions of Keynote, Pages and Numbers for FREE when you upgrade to OSX 10.9 Mavericks.

Is that true ? And how do I get them ?

Answer :

Yes, it’s true !

But… there is a tricky part in this… BEWARE !

This can ONLY be done BEFORE you upgrade to OSX 10.9 Mavericks, as it is a (deliberate) loophole in the OSX 10.9 Mavericks upgrade process :

Apple is shifting all installations of it’s software to the Mac App Store, and the OSX 10.9 Mavericks installer therefore checks for all previous versions of Apple app’s that you have installed on OSX 10.8 Mountain Lion…

all versions of Keynote, Pages, Numbers and Aperture (!) will be ‘upgraded’ to the latest Mac App Store versions of the same apps.

note : even trail-versions and illegally copied versions will be ‘upgraded’ to full legal versions for FREE !

So, get an old version of the iWork apps (and/or Aperture) installed before you upgrade to OSX 10.9 Mavericks, and you get the new versions for FREE.

Enjoy !

Donate Button (MacManusNL)