linking pictures to a drop down list then changing

I was able to create the link pictures to a drop down list following the Ron's instructions

Select Sheet2 and turn off Grid Lines
...<Tools>Options><View tab>Uncheck: Grid Lines

1)For each picture to be displayed:
1a. <Insert><Picture from file> (select picture and put it in the sheet).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the dropdown list text:
Example for a picture of an Elephant:
<Insert><Name><Define>
Names in Workbook: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of the items.

3)Create a dynamic range name that refers to that cell:
<Insert><Name><Define>
Names in Workbook: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.

5)With the picture selected, type this in the formula bar, then press [Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown list.


However, when I went back into the file to added new pic[name], the ShowMyPic does not bring in the new images.

The range names for all the new images match the originals so I don't understand why the new images are not captured. Is there an additional step required when modifying the original pictures in Sheet2?

Thank you

I just tried it following the directions you posted and it updated fine.
1. The name must have no spaces
2. is your data validation list dynamic and includes the new name
3. Did you name the range in sheet 2 exactly the same as the data validation list (i.e. picpenguins versus penguin)?