fixed : no internet connection while WiFi and LAN are okay (after running Jaksta)

Question :
I was running an app (Jaksta Media Recorder) that crashed. Now I am no longer able to make any connection to the internet from macOS using my regular settings. Safari, Apple Mail.app and Whatsapp for macOS can no longer get propper connection to the internet.
I have tried resetting my internet modem, and my VPN now works, but the apps still cannot get a propper internet connection… so it appears to be a DNS problem, but changing DNS servers didn’t help…

What can I do to solve this ?


Answer :
As you might have expected, Jaksta Media Recorder has caused this problem when it crashed… to fix it, do this :
– restart your Mac
– do not startup any apps, startup the Jaksta Media Recorder app first
– when the Jaksta Media Recorder window opens (where you can see your previous downloads a.k.a. recordings) go to the bottom left corner and put the slider (that is turned ON automatically) in the OFF position
– then quit the Jaksta Media Recorder app

That’s it !

enjoy šŸ˜‰

Note : Jaksta Media Recorder for Mac is no longer being supported, as of 2023 Jaksta is a Windows-only app, so if you run into any problems with Jaksta for Mac you are pretty much left hanging… so, if you’re looking fro an alternative for Jaksta, see this post :
fixed : current version (or replacement) for Jaksta downloader app on macOS

fixed : XLOOKUP function not available in latest version of MS Excel

Question :
I am running the latest version of MS Excel, but even though it should include the XLOOKUP function, it is not appearing when I want to use it in a formula.

What can I do to fix this ?


Answer :
The problem is that even though you have the latest version of MS Excel installed, the active license you have is one for MS Excel 2019 or earlier…
So, make sure you have a license for a newer version of MS Office for Mac, then do this :
– in Excel, click on “Excel” in the top menu bar
– from the pulldown menu, select “About Microsoft Excel”
– in the “About Excel” window that opens, at “License:” you will see “Office … 2019” (or something alike)
– now, go to the Microsoft website and download the License Removal Tool for Mac
– when downloaded, run the .pkg file and follow the online instructions
– when done, move the downloaded .pkg file to the trash
– then, open any MS Office app (e.g. Excel, Word, PowerPoint or Outlook)
– when prompted, typ your MS Office for Mac license code (for Office 365 or 2021 or newer)
– when done, restart your Mac to activate the license code
– then open Excel after startup and check : XLOOKUP will now be available under “Formulas” > “Lookup & Reference”

That’s it !
enjoy šŸ˜‰

Note :
Microsoft’s website has further details that you can find here : “How to remove Office license files on a Mac”

fixed : screen and Touch Bar stay black when starting up MacBook Pro

Question :
I was trying to start up my MacBook Pro this morning but when I did, nothing appeared on screen… the screen stayed black… even the Touch Bar above the keyboard stayed black… I think I could hear a distant startup chime sound, but that was all… no indication of any response to my start-up attempts…
I thought that the battery might be empty, so I plugged in the USB-C power cable (which unfortunately does not turn on any light that indicates it’s charging), but the result of my start-up attempts stayed the same : black screen, black Touch Bar and only a dim, distant start-up chime…
Is this some kind of hardware failure (broken screen) ? Or is this a software problem that I can fix myself ?

What can I do ?

Answer :
This is a software problem.
You can fix this by doing the following :
– simultaniously press this key combo on your MacBook Pro’s keyboard :
[CTRL] + [CMD] + [ON/OFF] for at least 5 seconds, then release

[CTRL] = the ‘Control’ key
[CMD] = the ‘Command’ key, the key with the stylized 4-leaf-clover, previously known as ‘Apple’ key
[ON/OFF] = the ‘Touch ID’ key on the far right of the Touch Bar that is used for starting up, shutting down, and Touch ID

…and now, your MacBook Pro should start-up as usual, starting with a white Apple logo appearing on your black screen…
if it still doesn’t work, use this slightly longer procedure :
– press the [ON/OFF] key for at least 10 seconds to shut down your MacBook Pro
– then press the [CTRL] + [CMD] + [ON/OFF] key combo for at least 5 seconds to start-up

…That’s it !
enjoy šŸ˜‰




fixed : contact Microsoft Office Helpdesk

Question :
I have questions about Microsoft products that go beyond regular issues that are documented in the FAQ. Previously, I would contact the Microsoft telephone Helpdesk ( NL 020-5001500 ), but if you call that number nowadays, you just get a voice message telling you to go online since the Helpdesk is no longer supporting direct contact to callersā€¦

But on the website mentioned, I am getting stuck in a loopā€¦ any progress I make sends me back to the same page were I can only typ a question, but there is no chat option given, even when specifically asking for ā€œtalk or chat to helpdeskā€ā€¦
Even Google searches or searching anywhere else on the Microsoft website, doesnā€™t get me to a page with a chat optionā€¦ Even the Microsoft-owned chatbots ChatGPT or BingChat AI canā€™t help meā€¦

What can I do ?

Answer :
Microsoftā€™s telephone helpdesk used to be greatā€¦ but the options for contacting Microsoft are a complete messā€¦ unbelievable !
But there is a chat helpdesk, but finding and contacting it is very complexā€¦ hereā€™s how to :

  • Do this on a computer (it can be done on an iPhone, but the web chat interface is not really suited for that)
  • Go to the Microsoft website using this link :
    https://support.microsoft.com/en-us/home/contact
  • Ā in the search field typ ā€œtalk to agentā€ and (click ā€œDoneā€ and) click the blue ā€œGet Helpā€ button
  • scroll down and click the blue ā€œContact Supportā€ button
  • on the next “Tell us a little more about your problem” page, select your product or service from the pop-up list (activate the list by clicking on the triangular arrow on the right of the selection box)
  • when the second pop-up list appears, select your support category
  • then click the blue ā€œConfirmā€ button
  • on the next page, click on ā€œChat with a support agent in your web browserā€
  • on the next page check if the email address shown corresponds to the one of the Microsoft account you are having problems with, if not typ the correct account email address first, the click the ā€œConfirmā€ button
  • now, wait for the live chat will start

    NOTE :Ā 
  • If you would prefer to chat in your local or native language, you need to tell this in the chat to the English speaking agent…
    (unfortunately, at the time of writing, the autoranslate service is not working and waiting queues for local language chats are extremely long, so chatting in English is about your only option…)

    That’s it !
    enjoy šŸ˜‰