Office Compatibility Issues

How to Fix the _xlfn. Prefix Before XMATCH in Excel

Ayan MasoodAyan Masood Nov 10, 2026 870 views

Question details

The user needs to remove the _xlfn. prefix that appears before the XMATCH function in their Excel workbook so the formula can calculate properly.

How to Fix the _xlfn. Prefix Before XMATCH in Excel
Product
Microsoft Excel
Device & OS
not provided
Scenario
Opening or editing an existing spreadsheet that contains the XMATCH function.
Observed behavior
The XMATCH function is prefixed with _xlfn., which indicates that the current Excel environment does not recognize the function due to version limitations or compatibility mode.
Before you start

Check your current Microsoft Excel version, as the XMATCH function is natively supported only in Microsoft 365, Excel 2021, and newer versions.

Solution 1Recommended

Update Excel and Disable Compatibility Mode

Use this solution to ensure your Excel environment is fully up-to-date and not restricting modern functions through legacy compatibility modes.

The _xlfn. prefix is Excel's way of indicating that a function exists in the workbook's code but is not supported by the version currently rendering it. Updating your software and checking the file format will usually resolve this.

1
Check for Office Updates

Open Excel, navigate to 'File' > 'Account' (or 'Office Account'), click on 'Update Options', and select 'Update Now' to install the latest Office updates.

2
Disable Compatibility Mode

Go to 'File' > 'Info'. If you see 'Compatibility Mode' next to the document name, click the 'Convert' button to upgrade the workbook to the current .xlsx format.

3
Refresh Formulas

After updating and converting, click into the cell containing the _xlfn.XMATCH formula, remove the _xlfn. prefix manually if it remains, and press Enter to recalculate.

Important Requirement: These steps will only restore the XMATCH functionality if your base Office license (like Microsoft 365) actually includes support for modern dynamic arrays.
Free Microsoft Office alternative

Switch to WPS Office to Handle Modern Spreadsheets

If your current version of Microsoft Office does not support newer functions like XMATCH and you want to avoid expensive subscription upgrades, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for modern spreadsheet tasks.

  1. 1. Download and Install: Visit the official WPS Office website to download and install the free software suite on your computer.
  2. 2. Open WPS Spreadsheets: Launch the WPS Spreadsheets application from your desktop or start menu.
  3. 3. Load Your Workbook: Open your existing .xlsx file directly in WPS Office to view, edit, and calculate your data without formatting issues.
Highly compatible with Microsoft Excel (.xlsx, .xls) formatsFree to use with a familiar, user-friendly interfaceRegularly updated to support a wide array of modern spreadsheet functionsLightweight installation with seamless migration from MS Office
microsoft office alternative - wps office

Frequently Asked Questions

What exactly does the _xlfn. prefix mean in Excel?

The _xlfn. prefix stands for 'Excel Function'. It is a marker automatically added by Excel when a workbook contains a function that is not natively supported by the specific version of Excel you are currently using.

Can I simply delete the _xlfn. prefix to make XMATCH work?

No. If you manually delete the _xlfn. prefix without updating Excel or replacing the function, Excel will still not recognize the formula and will instead return a #NAME? error.

Which versions of Microsoft Excel support the XMATCH function?

The XMATCH function is natively supported in Microsoft 365, Excel 2021, and Excel for the Web. It is not available in standalone older versions like Excel 2019, 2016, or 2013.

Why am I seeing this error if I have Microsoft 365?

If you have Microsoft 365 but still see this error, you might have opened an older .xls file in Compatibility Mode, or your Office installation may be experiencing a temporary background glitch that requires a quick restart or software update.