Awesome IMAGE function techniques you need to know! | Excel Off The Grid

[@elbadlis]

That quickchart there is awesomeeeeeee

[@ExcelOffTheGrid]

It is pretty nice isn't it. Sometimes you have to force a volatile calculation to make sure it recalculates when a file opens. But apart from that, I love it. Plus... it's free!!!

[@kebincui]

AWESOME AS ALWAYS. THANKS MARK👍

[@ExcelOffTheGrid]

Thanks Kebin 😁

[@MattHarris3]

Very cool examples, you're always a few steps ahead! :)

[@ExcelOffTheGrid]

😁 - Thanks. I'm always trying to push the boundries a bit.

[@chrism9037]

Great video. I always forget to use this function. Thanks Mark!

[@ExcelOffTheGrid]

The lack of ability to use local files, make it a little tricky to use sometimes. But hopefully the OneDrive/SharePoint technique from this video can reduce some of that.

[@IvanCortinas_ES]

Excellent topics. All sections are very good. Thank you for sharing them.

[@ExcelOffTheGrid]

Thanks Ivan, I appreciate that. 😁

[@eduardomunoz2764]

Thank you!.. really great video.

[@ExcelOffTheGrid]

Glad you liked it! 😁

[@vinhwizard]

awesome, thank you so much

[@ExcelOffTheGrid]

You're welcome!

[@jakubstesik472]

Incredible! Thank you!

[@ExcelOffTheGrid]

Thank you. I'm glad you liked it. 👍

[@GeertDelmulle]

Really great video, not in the least because of those websites! (Didn’t know about those.) Thanks Mark! :-)

[@ExcelOffTheGrid]

It can be a challenge to find them, but finding the right API website gives Excel new capabilities that we never thought possible.

[@maciejkopczynski55]

Am I correct to assume that the OneDrive method works only for OneDrive for Business or Educational? I tried all possible versions and this is my conclusion: 1. OneDrive Personal - IMAGE() does not work for OneDrive Personal links 2. OneDrive for Business or Educational M365 version IMAGE() works just as you described Mark. Awesome videos! Always looking forward to more!

[@ExcelOffTheGrid]

Correct. There maybe an alternative method for OneDrive Personal, but I’ve not tried any of them.

[@maciejkopczynski55]

@@ExcelOffTheGrid Thanks for confirming Mark!

[@ExcelOffTheGrid]

Sign up for our free Insiders program and get the example file: exceloffthegrid.com/insiders-signup/ File Reference for this video: 0217 Image Function Techniques.zip

[@AngelRivera-sg5ue]

is this only for 365 excel?

[@ExcelOffTheGrid]

Yes, it’s 365 only.