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

%3CLINGO-SUB%20id%3D%22lingo-sub-2555847%22%20slang%3D%22en-US%22%3EExcel%20Linked%20Pictures%20duplicating%20and%20remaining%20in%20place%20-%20making%20workbook%20unstable%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2555847%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Linked%20Pictures%20to%20display%20tables%20in%20a%20Dashboard.%20I%20have%20numerous%20pictures%20linked%2C%20around%2010%20-%2012.%20My%20file%20size%20is%20growing%20and%20the%20Workbook%20is%20now%20very%20unstable%2C%20going%20into%20'Not%20Responding'%20after%20any%20action.%3CBR%20%2F%3EI%20have%20just%20discovered%20that%20each%20of%20the%20Linked%20Pictures%20now%20have%20multiple%20copies%20of%20it%20on%20top%20of%20each%20other.%20I%20don't%20know%20how%20many%20as%20the%20Workbook%20is%20now%20very%20slow%20and%20it%20is%20difficult%20to%20delete%20the%20pictures.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EAnyone%20know%20why%20there%20are%20duplicate%20pictures%20piled%20up%20on%20top%20of%20each%20other%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2555847%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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' after any action.
I have just discovered that each of the Linked Pictures now have multiple copies of it on top of each other. I don't know how many as the Workbook is now very slow and it is difficult to delete the pictures. 

Anyone know why there are duplicate pictures piled up on top of each other?

1 Reply

@Kenny20 

If you have a lot of pictures, no matter if you compress them or convert them to gifs to take up little space, it becomes more and more.

Unfortunately, that's how it is with the pictures.

Here is a suggested solution, instead of loading the images onto the Excel file,

simply link them and call them up again and again from the specified folder.

So the storage space is directly the hard disk and not the Excel workbook.

A file with Userform has been inserted here where you can look at it yourself.

I had this file in my archive a long time ago that I unfortunately don't know from where.

Try it out, maybe it suits you as a solution. If not, just ignore it.

 

 

I would be happy to know if I could help.

 

NikolinoDE

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.