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...
For me the IMAGE formula works fine on one spreadsheet. I copied the (same) URL from there to another spreadsheet and it shows the CONNECT error.
One works, the other doesn't!
EDIT: SOLVED but this may help.
The problem was, the image URL no longer worked. BUT, the old spreadsheet was still 'showing' the image! Even 'refreshing it when the IMAGE formulas were being re-entered in another cell with VBA.
Looks like Excel is caching the image?
Excel caches practically everything what is taken from outside - rich data types, chart map, data in data model and in cached PivotTable. I'm almost sure images as well.
