Forum Discussion
Excel dynamic lookup image keeps duplicating itself - but the cause was because of array formula
I made a file using dynamic images to display an image based on another cell value. I used the method described in this video: https://youtu.be/wlW2UKml9CY Instead of a drop-down name picker, the dyn...
To add to my previous post:
1. if you don't see the duplication of images, it's because they are exactly on top of each other. Select the image on the top and move it a little, you'll see the original image lying right underneath it.
2. If you delete the duplicates, then click "Calculate now", duplication won't happen right there and then. It seems to always happen after I saved, closed and re-opened the file. I've been keeping deleting these duplicates, and they always pop back up after I opened the file again. Very frustrating.
yonghanwu Tried that as well. Can't replicate the error.
- I don't always get the error. I start to notice that I always have duplicates when Excel crashes by shutting itself off. And Excel crashes most likely if I had just done a bunch of calculations and then Ctrl+P and clicked "generate print preview".
It almost seems what Excel does when switching dynamic images is to make a copy then delete the old one. So if during the process of switching to different images, if it gets interrupted (crashes), then both copies of the images are kept -- that's my guess. If Excel crashes, when I re-open the file I always (I think) see doubles of the same images. If I wait a minute or two before I use print preview, it seems to reduce the chance of crashing.
The sample file I linked here is smaller so it is less likely to crash. My other file is a bit bigger (7mb). But I am surprised that Excel had trouble handling a 7MB file. My CPU is 2.6GHz, RAM 8GB, 64-bit. Windows 10 Pro; Hard drive 256GB with still 67GB left. And these crashes happened when I just had Excel and Edge running with a couple of tabs.