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...
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.
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.