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,

Paulina

1 Reply

@Paulina1982 

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