Office Compatibility Issues

Why Excel Adds _xlfn to TEXTJOIN and FILTER Formulas

Huma Ashraf ChHuma Ashraf Ch Nov 18, 2026 870 views

Question details

Determine why Excel adds compatibility prefixes to TEXTJOIN and FILTER formulas when a workbook is used on another computer.

Why Excel Adds _xlfn to TEXTJOIN and FILTER Formulas
Product
Microsoft Excel
Device & OS
not provided
Scenario
A workbook containing TEXTJOIN and FILTER formulas is opened or saved on another computer or operating system.
Observed behavior
Formulas display _xlfn and possibly _xlws prefixes after the workbook is saved.
Before you start

Check the Excel version on each computer that opens or saves the workbook. Note which formulas contain TEXTJOIN or FILTER and whether they calculate correctly.

Solution 1Recommended

Use an Excel version that supports both functions

Use this approach to preserve the original formulas and their dynamic behavior.

The _xlfn prefix indicates that a function may not be recognized by the Excel version handling the workbook. The _xlws prefix can also appear in the stored representation of dynamic array functions; its presence alone does not establish that a formula has failed.

TEXTJOIN is supported in Excel 2019 and later, including Microsoft 365. FILTER is available in Microsoft 365 and Excel 2021 and later. Differences in Excel versions and feature support, rather than Windows versus Mac alone, are usually the cause.

1
Check each Excel version

In Excel on Windows, open File > Account and check Product Information. On a Mac, open Excel > About Excel.

2
Update or upgrade Excel

On Windows, use File > Account > Update Options > Update Now if available. On a Mac, choose Help > Check for Updates. If the installed edition does not support FILTER, switch to a supported edition; ordinary updates to Excel 2019 do not add it.

3
Reopen and test the workbook

Open the workbook in the supported Excel version and check the affected cells. If a formula still does not calculate, re-enter it in the formula bar using the supported function name, then save the workbook.

Use an Excel version that supports both functions
Avoid manually removing prefixes: Removing _xlfn or _xlws by itself does not add missing function support to an older version of Excel.
Free Microsoft Office alternative

Work with Excel spreadsheets in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel file formats, making it easy to move existing workbooks. It does not update Microsoft Excel, so test important formulas and dynamic arrays in your WPS version before sharing.

Open and edit Microsoft Excel XLSX and XLS filesReview spreadsheet formulas in a familiar interfaceMove existing workbooks into a lightweight Office suiteUse free spreadsheet tools for everyday work
microsoft office alternative - wps office

Frequently Asked Questions

What does _xlfn mean in an Excel formula?

It is a compatibility prefix associated with a function that an Excel version may not recognize. Check the affected function and the Excel version under File > Account on Windows or Excel > About Excel on a Mac.

Does Excel 2019 support FILTER?

No. FILTER is available in Microsoft 365 and Excel 2021 and later. Excel 2019 supports TEXTJOIN but needs an alternative, such as Data > Filter, for FILTER results.

Why does _xlws appear before FILTER?

_xlws can be part of the stored representation of a dynamic array function. Check whether FILTER calculates in the installed Excel version rather than treating the prefix alone as proof of an error.

Is the problem caused by switching between Mac and Windows?

Usually the important factor is the Excel edition and its supported functions, not the operating system alone. Compare the Excel versions on both computers and test the formulas in each.

Can I just delete _xlfn from the formula?

Deleting the prefix will not make an unsupported function work. Open the workbook in a version that supports the function or replace the formula with a compatible alternative.