Forum Discussion
Phantom Photos: Images Duplicate Themselves Randomly in Excel Files Stored In SharePoint
kmnotorius 2022 and still having this problem. Files are saved to SharePoint. Duplication only happens when certain users access the file, so I'm assuming it's a problem with their computer, not all computers. Any linked photos or photos using the camera tool are duplicated each time the user accesses that file. If it is not caught quickly, the accumulation becomes so large that the file begins to work slowly. If it gets out of hand, the only way to fix it is to delete the tab because excel will lock up trying to select all objects and delete.
kvpool I found that I could open the file in Excel 365 on the web browser and delete duplicate images. Trying to open some of the files in desktop application would result in lockup like you mention.
- cwoodley Thanks! I'll remember that for future reference. Right now I just go in manually to the documents with this problem and delete before it gets out of control. Meanwhile, I need to come up with some sort of power automate or script to go in once a week and remove the extras on a schedule. Hopefully once we get everyone upgraded, that will solve the problem.