I have an image that i can insert in my spreadsheet but when the image changes the sheet does not reflect the new image. How do i get the sheet to automatically recognize and update the image? I tried adding the image to an html file and using link to external data but that didnt work either.
If you insert the image checking the “Insert as Link” option, updating works by selecting Edit → Links to External Files, selecting the image(s) and then Update.
I think you misread my question - i was looking for an automatic way.
How can this be done automatically? I’m thinking about ways like: a timed method like ‘links to external data’ or by detecting the file change if the image file gets updated on disk or by some other way?
My first idea was to embed the image in an html file with the img src html tag and then use ‘link to external data’’ to get it to update on a timed schedule but that doesn’t work, the image is ignored completely