Excel error: Issue: An _xlfn. prefix is displayed in front of a formula

Copper Contributor

Hi, I have opened up a database to select products from. However the pictures are not showing up. The error is a _xlfn. prefix. Can anyone please explain how I can fix this? I believe I have the newest version of excel. It displays "#NAME?"

7 Replies

@JackYT1 

Select File > Account.

Which product is listed on the right hand side, and which version/build?

@Hans Vogelaar 

The product is Microsoft 365. It Is version 2308, build (16731.20094) 

Product is Microsoft 365. version 2308, Build (16731.20094)
The product is Microsoft 365 and the version is 2308
It sounds like the workbook is using the IMAGE function and you're on the Semi-Annual Enterprise channel which does not yet have access to the function.

@JackYT1 

As far as I know, Microsoft 365 version 2308 should have the IMAGE function...

 

Are you sure it's Microsoft 365, and not Office 2021, 2019 or 2016 Click-to-Run? Those share the version numbers with Microsoft 365 but don't have new functions such as IMAGE.

@Hans Vogelaar 

Yes, it looks like you're correct. That's Current channel.

I guess the question for @JackYT1  is what comes after xlfn in the formula bar?