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:
• THE BEST way to add IM...
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. accessanalytic...
Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/
Connect with me
wyn.bio.link/

[@excelrobot]

Cool trick Wyn, thanks for sharing!

[@AccessAnalytic]

No worries

[@zzota]

Great tip. Thanks Wyn.

[@AccessAnalytic]

You’re welcome

[@Ikufario]

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

[@AccessAnalytic]

Have fun 😀

[@johnfromireland7551]

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

[@AccessAnalytic]

If a1=1 then tiger else rabbit …. Endless fun 😀

[@mienzillaz]

Always good stuff from Bas!

[@AccessAnalytic]

Absolutely!

[@brianxyz]

Is there a hack to use images stored locally?

[@AccessAnalytic]

Not that I'm aware of. You could insert the images you need into a hidden sheet and use some trickery to get a Shape to display the image you want to show, but it won't utilize the =IMAGE function

[@ashankasen]

Need Office 365 for this ...

[@AccessAnalytic]

Yes, I’ll try to remember to call that sort of thing out in future videos.

[@erikguzik8204]

Hmmmmm - 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

[@AccessAnalytic]

Odd. What’s the file extension of the image - png, jpg? And how big is the file?

[@IvanCortinas_ES]

Brutal trick. Thanks Wyn.

[@AccessAnalytic]

I don't know how Bas discovered that!?

[@safwanchaklasiya]

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

[@AccessAnalytic]

When you say local drive what do you mean sorry? This works with SharePoint

[@kailash680]

the onedrive embed link also works

[@AccessAnalytic]

Hi, which link is that?

[@fanlovexcel]

Nice trick👍

[@AccessAnalytic]

Thanks

[@-d-3969]

it work thank bro

[@AccessAnalytic]

You’re welcome.

[@seninallou2388]

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

[@AccessAnalytic]

Not sure sorry. I don’t know if the admin can add certain users to be allowed to share. Not my area of expertise. Might work with share inside your organisation too

[@seninallou2388]

@@AccessAnalytic Thanks very much for your feedback; I will look into this with my Sharepoint Admin👍👍

[@johnfromireland7551]

Your Admin (Securocrat) is concerned about "Data Leakage" and less concerned about using the full functionality of Microsoft tools to increase productivity and thus sales and income for the business. He is happier keeping the business small, restricted and destined to never grow. Fight the Securocrats!!

[@psz34]

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

[@brianxyz]

Excel.

[@AccessAnalytic]

The hack works in both, the =IMAGE function is Excel. Power BI images can be added to Buttons, Card Visuals, Slicers and Tables/Matrix visuals/