Forum Discussion
=Image returns a #connect error
Hi All, I'm experimenting with the new =Image function, and somehow I can't get it to work. I copied a file to my sharepoint site, set the permissions to "anyone can view". I copied the URL and paste...
The IMAGE function may point to a cell containing a URL. I have a workbook with several hundred links in another sheet and IMAGE works with them with no issue. I show/hide images with a drop down.
The #CONNECT error may be due to an unsupported file type or external content being blocked.
Image supports: BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP..
Details on external content:
https://support.microsoft.com/en-us/office/block-or-unblock-external-content-in-office-documents-10204ae0-0621-411f-b0d6-575b0847a795
The #CONNECT error may be due to an unsupported file type or external content being blocked.
Image supports: BMP, JPG/JPEG, GIF, TIFF, PNG, ICO, and WEBP..
Details on external content:
https://support.microsoft.com/en-us/office/block-or-unblock-external-content-in-office-documents-10204ae0-0621-411f-b0d6-575b0847a795
Thanks for your reply. I tried with a picture from my company website and it's working. The pictures I want to link are on my SharePoint site. If I click directly on the link, then the picture opens normally in my browser, I just can't get it to open in the file...
