Phantom Photos: Images Duplicate Themselves Randomly in Excel Files Stored In SharePoint

kmnotorius 

I came across this post and can confirm I have had this problem for a number of years.  All relating to the same environment as to what other people have mentioned in this thread.  FYI, I create my named ranges and create the picture links through VBA but I don't think that makes any difference.

However, I may have a partial solution as the issue doesn't crop up that often for me once I disable the links.  What I mean by this is that the links are dynamic through a named range but I made the named range formula have an If condition which references a specific cell.  It it's set to 1, it will update the picture links.  If it's set to 0 it will reference nothing and the images won't update.  This I find has helped keep duplicates at bay and sure enough on the times I forget to disable the links before saving and closing the file down - somewhere along the way a duplicate set of picture links appear and the file slows to a crawl (eg. I can tell it's happened when I highlight even just one cell and copy CTRL+C as excel freezes for a short time which is very frustrating when you are trying to work at speed).

Anyhow, if you understand what I'm suggesting in the named range formulas, give it a go.  If you need more info, feel free to reply.

Thanks

RodP