Solved How to access photos in Excel 2010

Dell Latitude e6510 laptop computer (int...
April 29, 2018 at 09:56:55
Specs: Windows 10, 2.3/8
I have photos that I want to include in an Excel 2010 spreadsheet. The photo are in a spreadsheet labelled "Photos." I can get the photos into the correct cell on the spreadsheet but they are too large. What I have trying to do without any success is access the appropriate cell that contains the photo needed which is on "Photos" spreadsheet when I click on the correct photo cell on the spreadsheet.

Thank you.
Brian W


See More: How to access photos in Excel 2010


✔ Best Answer
April 29, 2018 at 18:43:14
re: "I have a photo on Sheet4 that goes from cell A1 to cell F14"

You have a image on Sheet4 that covers the range from A1 to F14. The image is not in those cells, it's basically in front of them.

re: "I wrote =Sheet4!A1 which returned a "0""

That's because Sheet4!A1 is probably empty. Put a number in Sheet4!A1 and your formula will return the contents of Sheet4!A1, which is not the image.

re: "Where did I make my mistake?"

Your mistake was thinking that the image is in the cell. As noted earlier, it's not.

You can't reference a shape with a formula. You certainly can't "copy" or replicate a shape with a formula (because you can't reference a shape with a formula).

You might be able to do something with VBA, but there is no way for anyone to offer any suggestions based on what you have posted so far.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code



#1
April 29, 2018 at 10:57:31
Not to be facetious, but why not resize the photos before you input to Excel?

Unless each photo needs it's own dimensions?

I know that XnView has a Batch Resize so you can do all the photos at once.

Otherwise the only way, I believe, is with a Macro.

How are you accessing the photos within Excel, Hyperlink() function?

MIKE

http://www.skeptic.com/


Report •

#2
April 29, 2018 at 11:16:18
I gotta admit, I am totally confused.

re: "I can get the photos into the correct cell on the spreadsheet but they are too large"

How are you getting the photos in the correct cell?

re: "What I have trying to do without any success is access the appropriate cell that contains the photo needed which is on "Photos" spreadsheet when I click on the correct photo cell on the spreadsheet."

If you are clicking on the photo cell aren't you "accessing" it? If you know what cell it's in (because you said you can get the photos in the correct cell) then why can't you access it?

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

#3
April 29, 2018 at 12:26:03
Also, as a side note,
you can use the cell Comment feature to display a thumbnail type picture in the Comment box.
So as you cursors over a cell, the comment pops up with a picture.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
April 29, 2018 at 16:13:36
mmcconaghy and DerbyDad03,

Thank you for your responses. What I tried before did not work again.

I have a photo on Sheet4 that goes from cell A1 to cell F14. I want it go appear on Sheet3 starting at cell A1. On Sheet3, I wrote =Sheet4!A1 which returned a "0". Where did I make my mistake?

Thank you.
Brian W


Report •

#5
April 29, 2018 at 18:43:14
✔ Best Answer
re: "I have a photo on Sheet4 that goes from cell A1 to cell F14"

You have a image on Sheet4 that covers the range from A1 to F14. The image is not in those cells, it's basically in front of them.

re: "I wrote =Sheet4!A1 which returned a "0""

That's because Sheet4!A1 is probably empty. Put a number in Sheet4!A1 and your formula will return the contents of Sheet4!A1, which is not the image.

re: "Where did I make my mistake?"

Your mistake was thinking that the image is in the cell. As noted earlier, it's not.

You can't reference a shape with a formula. You certainly can't "copy" or replicate a shape with a formula (because you can't reference a shape with a formula).

You might be able to do something with VBA, but there is no way for anyone to offer any suggestions based on what you have posted so far.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Report •

Ask Question