BLOCKED images

Hi ZShark,

I have asked ChatGPT for an explanation since I also ran into the same issue.

Thankfully, I was able to create a Microsoft 365 and PowerApps Savant to assist me in situations like these. I have decided to forego the IMAGE() formula based on the response received from ChatGPT. Currently I run a VBA code to insert and embed the images as an object and it works perfectly for my needs. Here is the response I received from the Savant:

"The #BLOCKED! error message in Excel indicates that the image could not be loaded due to security settings or network restrictions. This error message is usually caused by the security settings of your computer or network, which might be blocking the image from being loaded.

To resolve this issue, you can try the following steps:

1. Check if you have an active internet connection and ensure that the website hosting the image is not blocked by your network.
2. Check if you have enabled the "Display images and external content" option in Excel. You can do this by going to File > Options > Trust Center > Trust Center Settings > External Content, and then selecting the "Enable all data connections" and "Enable automatic update for all workbook links" options.
3. Try using a different image or website to check if the issue is specific to the image you are trying to insert.
4. If the issue persists, you may need to contact your IT department or network administrator for further assistance.

It is worth noting that using the IMAGE() formula to insert images in Excel can cause the file size to become large, which can slow down the performance of the workbook. It is generally recommended to use other methods, such as inserting images directly into the worksheet or linking to external image files, to avoid this issue."

I hope this helps, have a nice day.

Best regards,

Capella_AI