Drop-down menu expands photo but resolution does not improve.

In the attached spreadsheet I have a pull-down menu in cell E5. It displays a blown up version of the relevant photos contained in the range C2:D3.

Unfortunately the displayed images in cells F5 and G5 are of poor quality. I want the quality to improve so that it displays with the same quality as shown in cells F8 and G8.

All the data for larger images exists in cells C2:D3. If I expand any of the pictures in those cells, the picture quality improves dramatically.

I realise I could simply make the images in cells C2:D3 larger (also expanding those cell sizes accordingly), but then the spreadsheet would become very large and much harder to navigate. Any suggestions?

Originally Posted by 6StringJazzer

The problem may have to do with how images are rendered on a Mac. I don't have a Mac for testing so I can't help much more.

The dimensions on the original photos up top are almost perfectly square, but in the lower versions the dimensions are a little wider than they are tall. This makes them look a little squashed. If you fix that so the ratio of height-to-width is the same in the originals at the top as it is in the selections on rows 5 and 8 it may tune up how the images are rendered. Just a wild guess. Right click on a photo then select Format Picture and look at the dimensions in the upper right corner of the Ribbon (hopefully it's the same on a Mac).

Hi Jeff,

Thanks for your latest reply.

I have now managed to test the file on a PC (actually Microsoft Windows running on my Mac under Parallels), and found that the photos in row 5 render perfectly. So the problem is most likely something to do with the way the photos are rendering in the Mac version of Excel compared to the PC version.

Actually I was hoping to be in a position to display photos on my iPad based on the pull down menu, but I see there is another problem in getting it to work due to a message on my iPad "This version of Excel doesn't support displaying or updating pictures linked to cells". I read somewhere that an iPad supports Parallels so i will try that.