Forum Discussion
IMAGE function not working
I'm trying to use the new IMAGE function on desktop Excel (win 11). Build 15726.20202
According to the availability info on https://support.microsoft.com/en-us/office/image-function-7e112975-5e52-4f2a-b9da-1d913d51f5d5?ns=excel&version=90&ui=en-us&rs=en-us&ad=us this function should work in my build.
However, it seems that EXCEL doesn't recognize it and shows #NAME error.
5 Replies
Hi Microsoft Team,
I’m an Excel 2016 user and really appreciate the product. However, I’ve noticed that the =IMAGE function is available only in Microsoft 365 and the web version.
Many of us who are using perpetual versions (Excel 2016 / 2019) would love to see this function back-ported. It’s a small but powerful feature that makes dashboards, catalogs, and reports much more useful.
Not everyone can move to 365, but we still look up to Excel for improvements. Adding =IMAGE to 2016 and 2019 via update would make these versions more practical and user-friendly.
Please consider including this in a future update.
Thanks for listening and for continuing to improve Excel!The IMAGE function is currently listed in the 'rolling out' phase on the M365 dashboard. Very soon.
https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=Excel%2CDesktop%2CRolling%20outRegarding this 101534 Feature ID, when is it supposed to be completed and implemented and in which versions (Excel 2016, 2021, Office 365...) will it be?
- It is the same for me, according to MyOnlineTrainigHub it is only in 365 beta channel... https://www.youtube.com/watch?v=A6FiDwu2ND0.
I found a working version at https://quickchart.io/documentation/generate-qr-codes-excel-google-sheets/ (enable macros).
I am using the IMAGE function for QR code generation so I may just bypass excel and generate it in PowerApps and upload the image to SharePoint which I know works.
