Forum Discussion
Solved
New Image Function
Is it possible to reference images stored in a OneDrive folder? I've tried copy the link from the OneDrive image and using which gets me #CONNECT! Any ideas Thanks
Any site which requires authentication, includes OneDrive, doesn't work with IMAGE().
Like this
=IMAGE("https://1drv.ms/u/s!AmbSxIyCxe5hktkARJfWxindUUDxyQ?e=OW2Gjb.jpg") - this didn't work. Have put the file type in the correct place?
I tried pasting this (Below) into a cell, and that took me to the correct image in my OneDrive
https://1drv.ms/u/s!AmbSxIyCxe5hktkARJfWxindUUDxyQ?e=OW2Gjb
I want to be able to have the image in the cell.
Thanks
=IMAGE("https://1drv.ms/u/s!AmbSxIyCxe5hktkARJfWxindUUDxyQ?e=OW2Gjb.jpg") - this didn't work. Have put the file type in the correct place?
I tried pasting this (Below) into a cell, and that took me to the correct image in my OneDrive
https://1drv.ms/u/s!AmbSxIyCxe5hktkARJfWxindUUDxyQ?e=OW2Gjb
I want to be able to have the image in the cell.
Thanks
I tried it using a OneDrive URL and the local OneDrive path equivalent - no good.
The bolded link may be coming into play here. Since IMAGE is still exclusive to the Beta Channel (Insider), I take this as 'it might work' but we're going to be safe and list it as not supported.
Insert images in cells with the IMAGE function in Excel (office.com)
Known issues
- If the URL to the image file you are using is pointing to a site that requires authentication, the image will not render.
- Zooming in and out with images in cells may distort the images.
- Moving between platforms (for example, Windows and Mac) may result in irregular image rendering.
- Thanks - The IMAGE function is now on general release - I'm not an Insider, and got the function today. Watching early insider YouTube videos (Just) mention that it doesn't work referencing OneDrive - but hoped that would be changed before general release. Out of interest I tried Google Sheets and their version of IMAGE doesn't allow reference to GoogleDrive.
I may have to think of another way to get images into my spreadsheet - I was so hopeful of the new function. It appeared to be a far better solution than I've used before.Any site which requires authentication, includes OneDrive, doesn't work with IMAGE().
SergeiBaklan Thank you. It not the answer I want, but you have saved me a lot of head scratching 😀. Back to the drawing board. It was going to be exactly what I have been waiting for.
- Good to know about General release. I've been using IMAGE since August, but my work computer has not received IMAGE yet. I have a workbook with several hundred image URLs and IMAGE pulls in the pictures without issue. There's a bit of a lag in navigation when all pictures are showing so I've created a show/hide toggle. The workbook is about 250 kb with no pictures showing and 15 mb with pictures showing. All in all, IMAGE is a cool new feature.
- Thanks for your help - Just tried Microsoft Excel support - completely useless. Maybe MS are still testing the links to OneDrive - I'll keep an eye on it AND try to solve it another way, it just would have been perfect for me.