Images, Charts, Objects Missing in Excel? How to Get Them Back!

This is a problem that occurs once a while in Excel: Some objects are not showing. Most often, images or charts are not showing. Here are the possible reasons if charts, objects or images are missing and how to get them back!

Possible reasons for missing images and charts in Excel

You had images, charts or other objects (e.g. drawing) in your Excel workbook, but now they are gone? There are basically two possibilities:

  1. You’ve (accidentally) deleted them?
  2. They are just not being displayed.

So, let’s see now how to get them back.

Reason 1: How to get images and charts back if you have deleted them

If you are sure that you have not accidentally deleted charts or images, just scroll down to reason number 2.

If you have deleted pictures, charts or objects, try these things:

  • Undo (Ctrl + Z) until pictures are shown.
    If you have already changed many things, you can repeat undo until the images and charts are back, copy them, redo as long as necessary and paste them.
  • Restore an older version of your file. Here is how to do that.

Reason 2: Simply display images within the Excel options

There is a hidden setting in Excel with says “For objects, show:”. Here you can select if you want to show all such objects. Objects are in general everything which is not inside cells. So everything from images, drawings, charts, drop-down lists, etc.

excel, options, show, all, drawing, image, missing, chart
Images, charts, drawings etc. missing? Click “For objects, show all” within the Excel options.

You can easily reactivate them. But it’s a little bit hidden:

  1. Go to File and click on Options.
  2. On the left side click on “Advanced”.
  3. Scroll down to the “Display options for this workbook:”. The last bullet point says “For objects, show:”. Set the tick at “All”.

That’s it

Image by Amanda Elizabeth from Pixabay

Henrik Schiffner is a freelance business consultant and software developer. He lives and works in Hamburg, Germany. Besides being an Excel enthusiast he loves photography and sports.

17 comments

  1. I want to thank you a lot. I had like 30 sheets with images and suddenly they were missing. got all of them back cause of you. thanks a ton.

  2. There’s no ‘Option’ option under File within my version 16.6 for MS 365 but, under View within Preferences, there is an option to ‘Display All’ for objects. This was checked but doesn’t work.

  3. Nope still not displaying.
    It is there in print preview though, just not visible in the spreadsheet…
    ???

  4. Ditto Archer Frye’s issue. By selecting all cells on a sheet and right clicking to “unhide”, all objects display on that sheet. But if I move to another sheet and then back to the prior, they are gone again. Also running 16.63 on MS365. Frustrating when moving between sheets.

  5. I have a Mac and there was no ‘Option’ link. However, I tried clicking on ‘Excel’ and found ‘Preferences’. Clicking on that gave a choice of icons including ‘View’ which then led to ‘For Objects, Show’ which was set on ‘Nothing’. I changed it to ‘All’ and all my pictures reappeared!

  6. My entire forecast exam disappeared 20 minuts before turn in. I didn’t know what had happend so I panicked and had to just scribble some answers and turn in the document as it was. Thanks to you I found out after that everything was still accessible, so i told my teacher about the document settings and now I will be judged fairly for the work i did. Thank you so much!

  7. Thank you a million. I don’t know what changed during upgrades etc., but suddenly my spreadsheet wasn’t showing *any* charts. This fixed it. *I* certainly did not set that option or change it.

Leave a comment

Your email address will not be published. Required fields are marked *