Why Excel Adds _xlfn to TEXTJOIN and FILTER Formulas
Question details
Determine why Excel adds compatibility prefixes to TEXTJOIN and FILTER formulas when a workbook is used on another computer.

- 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.
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.
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.
In Excel on Windows, open File > Account and check Product Information. On a Mac, open Excel > About 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.
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.

Replace unsupported formulas with older Excel features
Use compatible alternatives when a recipient cannot upgrade Excel.
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.

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.




