Jump to content
  • Windows 10 Forums

    Welcome to the Windows 10 forums, a free community where people just like you come together to discuss, share and learn how to use their computers.

    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. 

attaching pictures in OneDrive to Excel in Onedrive


Andrew

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).

Link to comment
Share on other sites

  • 3 weeks later...

 

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Who's Online   0 Members, 0 Anonymous, 9 Guests (See full list)

    • There are no registered users currently online
×
×
  • Create New...