Forum Discussion
XLOOKUP or XMATCH functions not available with EXCEL 2021
Hi all, I have Excel 2021 LTSC and i try to use XLOOKUP and XMATCH and they are not reconized. My version displayed in File>Account>About Excel is : Microsoft Excel MSO Version 2208 Build 16.0.156...
I've seen this crop up a few times with various versions of Office.
There's a few things you can try. I'd try it in this order:
1. Log out/in of your account through File | Account
2. Repair Office (I believe you'd get the MSI-based repair options).
Reference on repairing: https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b#:~:text=How%20to%20Repair%20My%20Office%201%20Right-click%20the,screen%20to%20complete%20the%20repair.%20.%20See%20More.
There's a few things you can try. I'd try it in this order:
1. Log out/in of your account through File | Account
2. Repair Office (I believe you'd get the MSI-based repair options).
Reference on repairing: https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b#:~:text=How%20to%20Repair%20My%20Office%201%20Right-click%20the,screen%20to%20complete%20the%20repair.%20.%20See%20More.
Patrick2788
Hi,
Many thanks for your help !
I tried both 1/ and 2/ without success 😞
According to the refrenced doc the next step sould be to completely uninstall Office and then reinstall it...
