Forum Discussion
Jeff_Deutch300
Apr 07, 2023Tin Contributor
Image Function adding Implicit intersection At operator Image Function not working
The Image function is not working properly as part of an automated template definition that is adding an At sign when the Excel opens the file. We believe this is due to the following upgrade in Exc...
- Apr 25, 2023
Jeff_Deutch300 SOLVED - formula should be #=_xlfn.image(x,x,x,x,x) - this works for the Caxlsx XML
Appreciate everyone's support in helping resolve this issue.
From Microsoft Support -Test Summary: Test File https://urldefense.com/v3/__https:/salsify-dandelion.s3-external-1.amazonaws.com/1/6462/user_data_export/1/2023/04/24/19*3A08*3A58-10a33c9c/export.xlsx?response-content-disposition=attachment*3B*20filename*3D*22KHC-*202023*20US*20Retail*20Digital*20Catalog*20Product*20Feed_2023_04_24_19_08_58_UTC.xlsx*22&response-content-type=application*2Fvnd.openxmlformats-officedocument.spreadsheetml.sheet&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARRX37GWVL5YUBHGV*2F20230424*2Fus-east-1*2Fs3*2Faws4_request&X-Amz-Date=20230424T190858Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=ea2b3974870e0e990178369cdd6f05da7480b52116cc9e07fe5f05c363418c5b__;JSUlJSUlJSUlJSUlJSUlJSUlJQ!!JtwtF54jn92Iq-I!aCVhjnBQZNjS82lkmMca6Qnv_MxsKLH10bqpZJmih2oGWUXvo8a_KEg45LLkVl_iftNuuP8PfxijSlJM3qQxTp6BzJSVJQ4D$
Lorenzo
Apr 08, 2023Silver Contributor
Running 365 Version 2303 Build 16227.20258 Current Channel / Windows
Opening the file you shared here is what I get (IMAGE function is avail. here no problem):
From there, if I select i.e. H2 and press Enter in the formula bar, I get:
Choosing Yes I get the expected Image :))
I suppose (???) this +/- reflects the issue you raised... Assuming this does, would you mind revising your formula in column H
From:
=IMAGE(AE2:AE2,A2,3,100,100)To (this fixed the issue here):
=IMAGE(AE2,A2,3,100,100)and let us know how it goes
- SergeiBaklanApr 08, 2023Diamond Contributor
IMHO, it shall work in any case if only the file is opened in proper Excel version. Using of implicit intersection operand shall not cause #NAME? error.
- LorenzoApr 08, 2023Silver Contributor
Agree, this should work in any case (but obviously this doesn't...)
I didn't want to confuse Jeff_Deutch300 with the following that also addresses the issue here (but raises question):
- SergeiBaklanApr 08, 2023Diamond Contributor
I'm not sure if + changes something for that function. And @IMAGE(AE2:AE2,.. shall work the same way as IMAGE(@AE2:AE2,...