Forum Discussion

Kenny20's avatar
Kenny20
Copper Contributor
Jul 16, 2021

Excel Linked Pictures duplicating and remaining in place - making workbook unstable

I am using Linked Pictures to display tables in a Dashboard. I have numerous pictures linked, around 10 - 12. My file size is growing and the Workbook is now very unstable, going into 'Not Responding...
excel
Formulas and Functions
Dbstedman's avatar
Dbstedman
Brass Contributor
Apr 14, 2022
I was reaaaaly hoping this was going to have a solution because I'm experiencing the same problem now. Did you ever figure out why the linked pictures were duplicating themselves?
  • Bobbloomer's avatar
    Bobbloomer
    Copper Contributor
    Jun 16, 2022

    It's been about (two months) a month since you asked, so if you're still looking for an answer.. I lucked into one.

    If you're working from a Onedrive account or a cloud account that enables the Autosave feature, each subsequent save makes another copy of the image. I turned off my autosave, cleared the multiple copies from their location on the page... and no more copies spawned. 

    It only cost me.. a save click every now and then.

     

    Hope that helps. It fixed mine, but YMMV.

     

    Dbstedman 

    • MichaelF79's avatar
      MichaelF79
      Brass Contributor
      Jul 25, 2022

      Bobbloomer That's unfortunate.  Having to choose between autosave or duplicates is a bad situation.  I am so used to just closing windows when I'm working in Office because it always autosaves... turning that off is risky for me!  I just can't believe this issue still exists... I am seeing posts about this bug going back several years.

Resources