• Welcome to Windows10Forum.com, a free community where people just like you come together to discuss, share and learn how to use their computers. Using this forum is easy and fun. As a guest, you can browse and view all the content on the site, however, you won't be able to leave comments or create new topics unless you create a free account. 

    Click here to Register a free account now and JOIN the discussion!

Andrew

attaching pictures in OneDrive to Excel in Onedrive

Recommended Posts

Hello.

Background:

I use an Excel spreadsheet as my issue list for large installation projects (flour mills, food factories, etc.).  I save it on my OneDrive so that I can access it on all of my devices, especially the iPad, when I'm running around the construction site.

Problem:

I want to have pictures of the issues in my spreadsheet.  My understanding is that it is not possible to 'insert' a picture directly into a single cell (I think there would be issues with sizing of the pictures anyway, and the size of the spreadsheet itself may cause issues for manipulating it on the iPad/iPhone).  Currently, I have my issue list spreadsheet saved in a folder on my OneDrive along with another folder that contains the pictures.  Using my laptop, I make links in the spreadsheet to the pictures saved in my OneDrive, and I am able to open them on my laptop as long as I login to OneDrive.  However, I am not able to open those links on my iPhone or iPad because the link path is to OneDrive via my laptop's disk drive (for example: C:\Users\Andre\OneDrive\...).  Furthermore, if I share the issue folder to anybody else, they cannot open the links either.

Question:

Is there an efficient and effective way to somehow place, link, or attach pictures into an excel spreadsheet on OneDrive that are able to be viewed on all devices and by anyone that I share the spreadsheet to? (Kind of like how you make an attachment on an email).

Share this post


Link to post
Share on other sites
On 6/9/2018 at 1:47 PM, Andrew said:

Is there an efficient and effective way to somehow place, link, or attach pictures into an excel spreadsheet

Hi @Andrew - For my install of Excel 2016, I add images by going to Insert > Pictures. See below.

Any reason you just don't use this feature?

image.png.bad8e5f958b037ceecc9d7fc8a948362.png

Share this post


Link to post
Share on other sites

 

On 6/26/2018 at 12:17 PM, Steve K. said:

Hi @Andrew - For my install of Excel 2016, I add images by going to Insert > Pictures. See below.

Any reason you just don't use this feature?

image.png.bad8e5f958b037ceecc9d7fc8a948362.png

Hi Steve,

I have tried that, but the pictures inserted are fully rendered to whatever resolution is allowed in the settings, and it clutters my issue list too much.  I am still working on figuring out how to reduce the quality of the pictures that I am embedding as objects in the spreadsheet.

Thank you nonetheless!

-Andrew

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now