Existing images are not saved
Created originally on Bitbucket by Peter Meijering
There has been (and there still is) an issue with images not being saved. Currently when I open my Excel file containing a set of images, change some data in different cells and store the file, my images are lost, but...
There is a work-around for this problem!
It seems that the images need to be 'triggered' to be saved. I had a workbook with identical images on 6 sheets. I saw that after modification of the file the images were not saved, but when I added an image before saving the file, this image was stored and also all other images, hence the act of adding an image triggered storing all the images. Now I have 5 pages containing the image and I add the 6th, so my Excel file is complete again.
In my opinion this should be fixed by always calling the 'save images' source code part when saving a modified Excel file.