Tag Archives: Office 2019

fixed : MS Auto Updater warning saying I need to upgrade eventhough I am already on the latest version

Posted on by
Reply

Question :
every time I restart my Mac, I get an error message from Microsoft saying that I can’t update, but I can’t find what’s wrong. When I click the link provided for more information, I get a page on the Microsoft website telling that support for MS Office 2019 for macOS has ended and that I should either updagrade to MS Office 365 or MS office 2021 for macOS… but as far as I know I am already running MS Office 2021 for macOS…

What is wrong ?

Answer :
Eventhough there is a very small chance that something completely different is going on, in the majority of cases, your problem will be that you are running the MS Office apps that you primarily use (e.g. Word, PowerPoint and Excel) in the 2021 version and some of the MS Office apps that you never use (e.g. Outlook, OneNote or OneDrive) are still on the 2019 version.

To solve this problem, do this :
– open the Finder
– go to [your Mac] > Library > Application Support > MAU2.0 > Microsoft Autoupdate
– doubleclick on Microsoft Autoupdate to run the MS Autoupdate.app
– click on the pulldown-button (top-right ; the downward-pointing triangular arrowhead)
– now the pulldown list of recent updates will fold out
– in the list, spot the apps that aregiving an error
– then click on the ‘Check for Updates’-button and wait for other updating errors to appear
– if the MS Office apps that you regularly use (e.g. Word, PowerPoint and/or Excel) are giving an update error saying you need to upgrade, your version of MS Office for macOS is outdated and you should buy the newest version or switch to an Office 365 (now called Microsoft 365) subscription
– if you only get updating errors for apps that you never use (e.g. Outlook), open a new Finder window
– then, goto [your Mac] > Applications
– then, type the name of the app you are looking for (e.g. Outlook) in the search field top right
– in the list of applications that appears, select the app you are looking for
– right-click on it’s name and choose Delete from the pulldown menu
– in the warning window that appears, typ your computer password (the password you use to startup & unlock your Mac) and click OK to allow the app to be deleted from you Mac

That’s it !

Enjoy πŸ˜‰

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

Posted on by
Reply

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”