Forum Discussion
Excel dynamic lookup image keeps duplicating itself - but the cause was because of array formula
yonghanwu Downloaded your file, removed the duplicate pictures. Changed nothing in the formulas or named ranges. Hence the dynamic array formula in D3 remains unchanged.
Pressed "Calculate now" many times. No duplication of the pictures occurred. Tested on both PC and Mac.
Thanks for helping me test this! It's very strange. The duplication almost always happened for me. It happened a few times even when I changed the array formula into single-cell formula.
Done another experiment, and it seems the duplication happens when the calculation option is set to "manual", then somehow upon file open, sometimes the images are doubled up. If it's set to "automatic" then it was not producing any duplicates. Maybe manual calculation is the culprit?
yonghanwustumbled across this and it's exactly what I'm experiencing. Sometimes it duplicates, sometimes it does not. Sometimes I see a blank image until I click around and wait, then it pops back up. It seems to ruin the performance of my sheet. Any luck? did you ever find a solution to this?
