Excel Error Codes

Fix _xlfn and _xlws Prefixes in Excel Formulas

Bushra ParveenBushra Parveen Nov 18, 2026 870 views

Question details

Identify and resolve _xlfn and _xlws prefixes that appear in Excel formulas.

Fix _xlfn and _xlws Prefixes in Excel Formulas
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user opens a workbook containing functions or features that their Excel installation may not recognize.
Observed behavior
Formula prefixes such as _xlfn or _xlws appear, and affected formulas may not calculate as expected.
Before you start

Select an affected cell and note the function name following the prefix, such as FILTER or XLOOKUP. Check which Excel version you are using and whether that function is supported in it.

Solution 1Recommended

Update Excel and check function support

Use this first when your Excel installation may be outdated or lacks a feature available in newer releases.

1
Check your Excel version

In Excel for Windows, open File > Account and review the product and version information. On a Mac, choose Excel > About Microsoft Excel.

2
Install available updates

In Excel for Windows, select File > Account > Update Options > Update Now. On a Mac, select Help > Check for Updates and follow the prompts.

3
Check your license and function

Under File > Account on Windows, check the product activation status. Compare the affected function's availability with your Excel version and license; an update alone cannot add a function that your edition does not support.

4
Reopen the workbook

Close and reopen the workbook in the updated Excel installation, then select the affected cell to check its formula and result.

Update Excel and check function support
Update options may differ: If Update Options is unavailable, your organization or installation method may manage updates. Contact your administrator or use the update method for your installation.
Free Microsoft Office alternative

Work with Excel Workbooks in WPS Spreadsheet

WPS Office is a free, lightweight Office alternative with a familiar interface and support for common Excel formats, making it easy to bring existing workbooks into WPS Spreadsheet. Check important formulas after opening, as support for newer Excel functions may vary.

Open and edit spreadsheets in a familiar interface.Supports Microsoft Excel formats such as XLSX and XLS.Review formulas and results when moving a workbook from Excel.Use a free, lightweight alternative for everyday spreadsheet work.
microsoft office alternative - wps office

Frequently Asked Questions

What does _xlfn mean in an Excel formula?

The _xlfn prefix usually identifies a function that the current Excel version does not recognize. Check the function name in the formula bar and compare it with the functions supported by your Excel version.

Why does _xlws appear before a function name?

The _xlws prefix can appear with newer worksheet functions, often alongside _xlfn. It may indicate that the Excel version opening the workbook does not fully support the formula or its features.

Will updating Excel always remove these prefixes?

Not necessarily. Use File > Account > Update Options > Update Now on Windows, then check whether your Excel edition supports the affected function. Some functions require a newer edition or a qualifying Microsoft 365 version.

Can I replace XLOOKUP in an older version of Excel?

Some XLOOKUP formulas can be rewritten with INDEX and MATCH. Edit the affected cell in the formula bar and test the replacement carefully, especially for missing matches and return behavior.

Does Office Online Repair add missing Excel functions?

No. Online Repair can fix Office installation problems, but it cannot add functions that your Excel edition does not support. On Windows, find Microsoft Office under Settings > Apps, select Modify, and choose Online Repair.