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!!!
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.
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
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!
AWESOME AS ALWAYS. THANKS MARK👍
Thanks Kebin 😁
That quickchart there is awesomeeeeeee
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!!!
Very cool examples, you're always a few steps ahead! :)
😁 - Thanks. I'm always trying to push the boundries a bit.
Great video. I always forget to use this function. Thanks Mark!
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.
Excellent topics. All sections are very good. Thank you for sharing them.
Thanks Ivan, I appreciate that. 😁
Thank you!.. really great video.
Glad you liked it! 😁
awesome, thank you so much
You're welcome!
Really great video, not in the least because of those websites! (Didn’t know about those.)
Thanks Mark! :-)
It can be a challenge to find them, but finding the right API website gives Excel new capabilities that we never thought possible.
Incredible! Thank you!
Thank you. I'm glad you liked it. 👍
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
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!
Correct.
There maybe an alternative method for OneDrive Personal, but I’ve not tried any of them.
@@ExcelOffTheGrid Thanks for confirming Mark!
is this only for 365 excel?
Yes, it’s 365 only.