Issue with excel formula starting _xlfn.

Copper Contributor

Hi there, I'm working on a file which contains formulas staring with prefix _xlfn. which is displaying as #NAME? error value. How do I get rid of that or stop that from happening?


Many thanks,


1 Reply


This means that the function is not supported in your Excel version. The resolution for this issue is given in the link.

Issue: An _xlfn. prefix is displayed in front of a formula - Microsoft Support