Forum Discussion
JackYT1
Aug 29, 2023Copper Contributor
Excel error: Issue: An _xlfn. prefix is displayed in front of a formula
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 newe...
JackYT1
Aug 29, 2023Copper Contributor
The product is Microsoft 365. It Is version 2308, build (16731.20094)
HansVogelaar
Aug 29, 2023MVP
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.
- Patrick2788Aug 29, 2023Silver Contributor
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?