Forum Discussion

pevans1350's avatar
pevans1350
Copper Contributor
May 01, 2024

Help! Image disappears when you click on it in Excel, with the message "Picture" appearing instead

Hi.   I have a spreadsheet with 200 rows that contains one image in each row of column A. I inserted these images by Insert > Picture > Place Over Cell (then I rotated it as neccessary) > then I cl...
Excel
pevans1350's avatar
pevans1350
Copper Contributor

Hi georgejbull Unforuntely not, sorry. Agree, it is very frustrating. 

particle16's avatar
particle16
Copper Contributor
Aug 09, 2024

pevans1350 

The picture icon at the corner of the image stopped working for me.  Instead try right clicking on the image and selecting Picture in Cell ---> Place Over Cell from the menu.  This will move the picture out and make it visible again.  I would then click on the icon at the corner of the picture to place it back in the cell.  Annoying, but it works.

  • OKCK68's avatar
    OKCK68
    Copper Contributor
    Oct 08, 2024

    particle16 I have the same issue, the biggest problem is not putting the image back.My biggest issue is that when I send the file, some images appear and others appear with !VALUE! in the cell where the pic used to be. 

    Some other pictures in the file appear just fine! 
    I suppose there is “something” there because the file is very heavy! 
    Please help!

  • CJ_McCollough's avatar
    CJ_McCollough
    Copper Contributor
    Oct 24, 2024

    particle16  Thanks- this may work for some people but it is not an option for a large list that needs to be filtered. (I have approx 1500 icons.) If you ever figure out a different way. Please let me know.

Resources