How to display an image from SharePoint or OneDrive in Excel

How to display images in Excel from SharePoint using =IMAGE

Thanks to Bas for the original idea on his Power BI video here:

Did you know I've written a book "Power BI for the Excel Analyst"?

Connect with me

[Ikufario]

Game changer? Yep, can be. I will test it tomorrow.

[johnfromireland]

Ha ha ha! Now I can have little chipmunks in my Excel workbook, too! Yes!

[seninallou]

Hi Wyn, that is cool. what to do when the share with "anynone button" is disable by the sharepoint admin in an organisation? your advice is greatly appreciated. thanks

[brianxyz]

Is there a hack to use images stored locally?

[safwanchaklasiya]

but when I provide address of the image of the local drive getting error of value

[erikguzik]

- i tried it from OneDrive and I still get a #VALUE error . retried the same steps a couple of times, Its probably me but i set to share, anyone, apply, and copy link, paste into IMAGE("{paste}") and replace the end after the ? download=1 and still get the error

[wendyc]

This was exciting but mine says "#CONNECT!" and doesn't work - any idea why?

[tonkrol]

I've tried this, but my Excel (Office 365) still shows '#Value'. I can't reproduce this with my Onedrive images !

[psz]

I don't get it - is it in Excel or Power BI?