Forum Discussion
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...
I find this just disgusting as a paying customer ... I now have over 4000 duplicated pics on around 200 excel docs and can only slowly remove each pic one at a time (IF I CAN ACTUALLY GET EXCEL TO WORK !!!!!!!!!!!!!!!! ....
Guys if you are using autosave on one drive or the likes STOP NOW before you end up like me with around 800000 pics to remove manually !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Guys if you are using autosave on one drive or the likes STOP NOW before you end up like me with around 800000 pics to remove manually !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Re: Excel Linked Pictures duplicating and remaining in place - making workbook unstable
I too am dealing with this issue and can't seem to do anything to fix it. It's very costly in time and efficiency for the client and the developer to have to spend hours re-opening a non-responsive excel file just to get like a few duplications deleted and seeing there are well above 10,000 images... When in reality your file had like 20 original images. I have been searching for a better solution. If anyone is able to help that would be much appreciated.
- I found that it duplicates the linked images every time it autosaves. The only solution is to switch off autosave and save manually. A bit of a hassle but the Excel file remains small and no duplication of the images.
