Forum Discussion
New Image Function
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.
Sorry if I misunderstood the question, I guess you asked does it work with OneDrive or not.
I did find a solution from YouTube. https://www.youtube.com/@MyOnlineTrainingHub.
In OneDrive if I use the Embed option on the image, and then use the Generate to create the HTML code. I've then copied https address to a spreadsheet cell, and then using that cell reference in the IMAGE function. This is a lot of work but does work.
The hover over the image which in the beta version popped up a larger image doesn't work on my spreadsheet. Others have suggested that this feature was removed on the release version.
Thanks to all.- You answered my question perfectly
I didn't make myself clear, I was trying to say you have saved me a lot of time trying to make something that doesn't work, work