Excel XLFN | Exceljet

Skip to main content

You are here

Home › Glossary › XLFN XLFN

If you open up a spreadsheet that you did not create, you may run into the "__xlfn" prefix before certain functions. The generic meaning of xlfn is "unsupported function". Typically, it indicates that the worksheet was created in a newer version of Excel and uses functions not yet available in the version currently running.

In the example shown, the UNIQUE function is used to extract unique values from a range of data. UNIQUE is only available in Excel 365, and was introduced in 2020. When the workbook is opened in an older version of Excel, the __xlfn prefix appears. Note that the original result is still displayed. However, the formula will not update to show a new result if data changes.

Solution or workaround

If you open the same workbook in a version of Excel that contains the missing function(s), the _xlfn prefix will disappear and the function will calculate normally. If this is not possible, you might be able to use another formula that does not rely on the newer function.

Topics

• Formula Basics
• Formula Examples
• Conditional Formatting
• Pivot Tables
• Excel Tables
• Excel Charts
• Shortcuts
• More...

Key Functions

• IF function
• VLOOKUP function
• XLOOKUP function
• FILTER function
• SUMIFS function
• COUNTIFS function
• SUMPRODUCT function
• INDEX and MATCH
• New Excel Functions
• All Excel Functions

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

  

Hey just wanted to say thanks for this fantastic blog. The dynamic worksheet reference using INDIRECT saved me today. Annie More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles