The Excel _xlfn. prefix indicates that your workbook contains a function that is not supported by your version of Excel.

This is a common error you many receive, especially is someone sends you a spreadsheet. Most corporate computers do not contain the most recent version of Excel.

Unfortunately, if you see this error, the workbook will not work correctly. You can obviously rewrite the formula with something compatible.

_xlfn. prefix

Here are list of Functions not supported in Versions earlier than Excel 2007

Function not supported in Excel versions in 2019

Leave a Reply


You can use Randbetween random Number Generation for a number or purposes in Excel. The Excel RANDBETWEEN function returns a

Read More »

VBA ColorIndex

Colors Colors could be very important and useful in excel application. There are two ways in which you can get

Read More »


The Excel ISOWEEKNUM function takes a specified date and returns a week number (1-54). The returned week follows the ISO

Read More »
Scroll to Top