Excel forumlas no longer working (Mac)

Copper Contributor

Using Excel for Mac v16.78.3 on Mac Monteray 12.7.1


Formulas like xlookup are no longer recognised by Excel? Stopped working 2 days ago and before that it was absolutely fine.

Any ideas? Very frustrating when all your workbooks contain a formula that no longer works?



1 Reply


If Excel formulas like XLOOKUP are no longer recognized by Excel on your Mac, there are a few things you can try to troubleshoot and resolve the issue:

  1. Update Excel: Ensure that you have the latest updates and patches for Excel. Sometimes, formula-related issues are resolved in software updates. You can check for updates by going to "Help" > "Check for Updates" in Excel.
  2. Check Formula Syntax: Double-check the syntax of the formula to make sure it's correct. Excel for Mac should recognize the XLOOKUP function. Ensure that you are using the correct arguments and that there are no typos or errors in the formula.
  3. Try Other Formulas: Test with other Excel functions/formulas to see if it's a specific issue with the XLOOKUP function or if other formulas are affected as well. This can help you determine if the problem is more widespread.
  4. Try in a New Workbook: Create a new, blank Excel workbook and test the XLOOKUP formula there. This will help you determine if the issue is specific to your existing workbooks or if it's a general problem with Excel.
  5. Check Excel Options:
    • Go to "Excel" > "Preferences."
    • In the Preferences window, check the "Calculation" category to ensure that calculations are set to "Automatic."
    • Check the "View" category to ensure that "Formulas" is not enabled.
  6. Add-Ins or Com Add-Ins: Sometimes, third-party add-ins or COM add-ins can conflict with Excel functions. Try disabling any add-ins you have and see if that resolves the issue.
  7. Check System Language and Region Settings: Sometimes, issues can arise if there are conflicts with system language and region settings. Ensure that your system settings match your intended language and region.
  8. Check for Third-Party Software Conflicts: Certain third-party software or system utilities can interfere with Excel's functioning. You can try disabling or uninstalling third-party software to see if it resolves the issue.
  9. Reinstall Excel: If none of the above solutions work, you might consider uninstalling and then reinstalling Excel on your Mac. This will ensure you have a clean installation of Excel.

Keep in mind that Excel on Mac should support functions like XLOOKUP. If you have ruled out any formula or syntax issues, it is possible that an update or conflict is causing the problem, and the steps above should help you identify and resolve it. The text was created with the help of AI.


My answers are voluntary and without guarantee!


Hope this will help you.


Was the answer useful? Mark as best response and like it!

This will help all forum participants.