Tag Archives: not available

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”

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)