fixed : internet on wireless but not on LAN according to AirPort Utility

Question :

Lately I have had a bad and unstable internet connection. I have a Mac and it has been working fine for years. My internet provider is Vodafone-Ziggo.

I tried to find out what was wrong using the AirPortUtility.app on my Mac, and I found something strange : when selecting my wireless WiFi-network, my internet connection is presumed working, but when selecting my wired LAN-network, I get an error message saying there is no internet connection.

If it would have been the other way around, I could think of an explanation… but having wireless internet connection from my router and not LAN-internet just doesn’t make sense…

I’ve tried numerous resets of the Ziggo-modem, of my TimeCapsule and of my Mac. Nothing helps.

Do you have any suggestions on fixing this ?

 

Answer :

Even though¬†you’ve tried most of the available options already, there is one other thing I would suggest to try :

  • make sure the UTP/Ethernet/LAN-cable is correctly connected into both your Mac and the ‘local network device’ (be it a TimeCapsule, a router, a modem, a network-switch or a wall-socket)
  • then, on your Mac : click on the Apple-icon (top-left on your Mac’s desktop screen)
  • in the pulldown menu, click on “System Preferences”
  • in the window that opens (“System Preferences”), click on “Network”
  • in the window that opens (“Network”), click on “Ethernet” in the list on the left
  • in the info that appears on the right, check if it says “Status : Connected”
  • if it doesn’t, your UTP/Ethernet/LAN-cable isn’t connected properly, so check all network-cables again until it says¬†“Status : Connected”
  • then, click the Advanced-button
  • in the window that opens, click on the DNS-tab
  • in the info that opens, at “DNS Servers:” make sure that you have at least included one of the following DNS Servers : 8.8.8.8 (Google), 8.8.4.4 (Google), 208.67.222.222 (OpenDNS) and/or 208.67.220.220 (OpenDNS)
  • if none of those DNS Servers are listed yet, add them by clicking on the +/Plus-button bottom-left
  • then click on the Proxies-tab (of the elongated TCP/IP-button)
  • in the info that opens, make sure to remove the check-mark at both “Web Proxy (HTTP)” and “Secure Web Proxy (HTTPS)”
  • in case both were already switched OFF, I would suggest to switch both of them to ON
  • then leave the rest as is, and click on the OK-button
  • in the previous window that appears, click the “Apply”
  • now check the AirPortUtility.app again, and you should see that the internet connection is back up for both the wireless and wired/LAN connection
  • also check by opening Safari (or another internet browser) and refresh the page by clicking on the circular arrow in the address bar

That’s it !

enjoy ūüėČ

fixed : new iPhone photos not showing up in macOS Photos.app

Question :

I am trying to get my photos from my iPhone onto my Mac. But after connecting my iPhone using USB the Photos.app does start up in macOS, but the newest photos I’ve made with my iPhone never show up my Mac.

Disconnecting and reconnecting my iPhone doesn’t help. Restarting the iPhone doesn’t resolve this problem, neither does restarting my Mac.

What can I do to solve this ?

 

Answer :

Even though you are encountering a very annoying problem, it’s rather easy to solve :

  • disconnect your iPhone (or iPad) from your Mac
  • open the Photos.app in iOS (on your iPhone/iPad)
  • click on the Photos-button (bottom-left ; the icon consisting of a double rectangle with the text ‘Photos’ below it)
  • select¬†one photo one of the newest photos
  • then click on the Share-button (bottom-left ; the icon consisting of a square with an arrow pointing upward)
  • select all photos that are not showing up on you Mac, by swiping the photos to the left and right and tapping the bottom-right circle of each individual missing photo (the circle will turn into a blue checkmark)
  • then swipe in the row of app-icons to the Shared Albums icon and click it
  • wait while the clock says ‘Preparing’
  • then click Cancel (top-left)
  • now connect your iPhone (or iPad) to your Mac
  • open the Photos.app in macOS (on your Mac)
  • unlock your iPhone (or iPad) using your fingerprint/face-scan/screen-unlock-code
  • then, on your Mac, in Photos.app goto¬†the left side bar and at Devices, click on your iPhone/iPad
  • then wait for the photos to appear as New Items
  • and click on the Import All New Items button top-right (or select only the photos you want to import and click on the Import Selected button)

That’s it !

enjoy ūüėČ

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)