IMAGE function in Excel does not update automatically

Question

I have images from weblink inserted in Excel cells. Unfortunately, they do not update automatically. Is there a setting to change to have it update automatically ?

Is there a way to even do it manually ?

Thanks

Answer 1

can you show in an example how and where you added time stamp to url?

Answer 2

Adding a timestamp in the url does it.

I basically added a "&t="&NOW()

Answer 3

I found a way...

If you change one letter in the link then send it (load), then reverse it back to the original (load), it reloads it with the update.

The only problem, I have a whole list in a sheet. Address in cell B1, B2, B3, etc...

How can I write a macro without having to record it for every single cell ?

Answer 4

Hello Fuad,

Thanks for your reply. I am familiar with Macro, so how would you do that ?

Answer 5

Hello,

Thank you for coming to the forum, my name is Fuad, and I will be happy to assist you in the best way I can.

Excel essentially captures the image at that point in time and displays it within the cell. Any changes to the source image on the web will not be reflected in the Excel cell automatically.

I don't know if this can be achieved with a Macro, and you run it manually. I can try to write one and test it, if you are interested, and know how to use Macros.

Give me time to check and I will get back to you.

Best Regards

Fuad

Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.