Carl Pepperseed, on assignment in the Burmese Jungle, reports that his =IMAGE() function in Excel suddenly started returning a #CONNECT! error. While we all feel bad for Carl, maybe that means that IMAGE is now Dynamic? If we could just figure out what Carl did to bring that #CONNECT! error!
How about F9? No.
How about Ctrl+Alt+F9? No.
How about F2 / Enter? No.
Replace the URL and then Undo? The image is still there.
Copy the sheet within the workbook? No.
How about Copy the Sheet to a new Workbook? That seems to be it.
Which is bad news for the people hoping for Dynamic IMAGE function.
How about F9? No.
How about Ctrl+Alt+F9? No.
How about F2 / Enter? No.
Replace the URL and then Undo? The image is still there.
Copy the sheet within the workbook? No.
How about Copy the Sheet to a new Workbook? That seems to be it.
Which is bad news for the people hoping for Dynamic IMAGE function.
Transcript of the video:
Carl Pepperseed.
Doing an Excel seminar. And hisIMAGE function returns a #CONNECT! error.
Maybe that means that IMAGE is now dynamic? Three IMAGE functions here.
This one we deleted from the server. Carl managed to get a #CONNECT! error here. What could it be?
How about F2, Eenter? It still comes back.
Let's put a different URL there. I get a #CONNECT! error, but then if I Undo, it comes right back. That image is stored inside this workbook and there's nothing we can do to make it go away. UNLESS we do this: right-click, Move or Copy, Create a copy, New Book. Click OK.
Ah, there. Now, see picture #3 changed.
Picture #2 is no longer there. So the cached image must not be attached to the worksheet, it must be in the workbook. That's kind of the worst answer: Bad for Carl. Bad for everyone else.
IMAGE is still not dynamic.
Doing an Excel seminar. And hisIMAGE function returns a #CONNECT! error.
Maybe that means that IMAGE is now dynamic? Three IMAGE functions here.
This one we deleted from the server. Carl managed to get a #CONNECT! error here. What could it be?
How about F2, Eenter? It still comes back.
Let's put a different URL there. I get a #CONNECT! error, but then if I Undo, it comes right back. That image is stored inside this workbook and there's nothing we can do to make it go away. UNLESS we do this: right-click, Move or Copy, Create a copy, New Book. Click OK.
Ah, there. Now, see picture #3 changed.
Picture #2 is no longer there. So the cached image must not be attached to the worksheet, it must be in the workbook. That's kind of the worst answer: Bad for Carl. Bad for everyone else.
IMAGE is still not dynamic.
