Forum Discussion
New Image Function
- Dec 13, 2022
Any site which requires authentication, includes OneDrive, doesn't work with IMAGE().
=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
Anthony Williams I wonder if the problem here is that you're using a shortened URL in your IMAGE formula as opposed to a link which points directly to the picture itself (and not your OneDrive folder).
I have successfully used IMAGE to link to pictures which are stored on our company Sharepoint. Not exactly the same as OneDrive, but similar. The key was finding the direct URL to the picture.
When I click on your image link it opens up a full-length URL as follows:
https://onedrive.live.com/?authkey=%21AESX1sYp3VFA8ck&cid=61EEC5828CC4D266&id=61EEC5828CC4D266%21306304&parId=61EEC5828CC4D266%21306333&o=OneUp
Then if I right-click your image and select "Copy Image Address", I get a different URL again:
https://am3pap003files.storage.live.com/y4mkekQgEZTA1704VWjJHitslT58O4r36wAYympVEqUaw3Dv5ceBGnM1JKxi8Xmd8xozlkAh626EeDD52rLElaz5QjmcXBsaQlWcZoe-5jjhybsVdABeWtata5eYQ7GYpguF4LVKF7NgktFkGKD4j3V2KVqncZ26GU16cmjaQTbcW98aI7ZSSY48KMoDGDaiAHzdaqf0nZaL3jutd1QmiDcTQ/P1150415.JPG?psid=1&width=805&height=804
Unfortunatly this image address URL seems to be too long to work with the IMAGE function.
Do you have access to any Sharepoint folders which you could use instead? These might result in shorter, usable image URLs.
In my case, the Sharepoint URL is formatted as follows:
https://mysharepointsite.sharepoint.com/sites/mypagename/myfoldername/mypicture.png
This IMAGE formula has changed my life by the way, it's fantastic !!! Hope you get it working.
- phand2390Jun 21, 2023Copper Contributor
Must the image in question be made public? I have ensured that the image followed the format you wrote but still showing #connect or #busy in excel.
- OfficeUniverseDec 17, 2023Copper ContributorHere is the solution for pulling images from onedrive:
https://youtu.be/Z5HcAK5vNbk- Anthony WilliamsDec 17, 2023Brass Contributor
Very helpful. Thanks
- vinod_DeekshitJun 23, 2023Copper Contributor
I tried using this image function in one drive.I didnt work.But fortunately one morning i was able to render the images submitted from form.But this lasted for only 2 hours
after that how much ever i try, i am not able to render the images..
We can render images in local 😧 and shared folders.
I feel we should use google sheets to get the solution.
If any one has a different solution, please share the same.
Rgds
Vinod