How to know the original path of an inserted image ?
Hi all,
I have a problem with an Excel file. In this file I used the feature “Insert image above cell” and I chose an image from a local path (on my hard drive). So far so good.
However, if I copy the file to another computer, the image is gone. That’s the concept.
Now the problem is that this an auto-generated Excel file from an external program. I know where the images are but I generated multiple reports, modified some of the images and changed the images in some excel files to point to other folders. It works fine on the original computer but I copied the Excel files and the images (or so I thought) to the other computer and some images are missing.
The question is : how do I know the original path of the image so that I can also copy it and re-link it.
The additionnal question to that is : I modified the local image for some reason (didn’t change the path) and I want to update the shown image to include my modification without closing and opening again the Excel file. Is that possible and how ? But the first question is really more important because basically I have a new laptop and I need to recover the whole file and images to export it if needed later in time when I won’t have the old laptop anymore.
Hi all,I have a problem with an Excel file. In this file I used the feature “Insert image above cell” and I chose an image from a local path (on my hard drive). So far so good. However, if I copy the file to another computer, the image is gone. That’s the concept.Now the problem is that this an auto-generated Excel file from an external program. I know where the images are but I generated multiple reports, modified some of the images and changed the images in some excel files to point to other folders. It works fine on the original computer but I copied the Excel files and the images (or so I thought) to the other computer and some images are missing.The question is : how do I know the original path of the image so that I can also copy it and re-link it. The additionnal question to that is : I modified the local image for some reason (didn’t change the path) and I want to update the shown image to include my modification without closing and opening again the Excel file. Is that possible and how ? But the first question is really more important because basically I have a new laptop and I need to recover the whole file and images to export it if needed later in time when I won’t have the old laptop anymore. Read More