well it worked great - right up until
In addition to the charts that are in the workbook -
I have several in another workbook (all sitting on sharepoint)
I did as before - and made sure the worksheet name was a part of the image name
I did a copy and when I pasted to my other workbook - it added the workbook name - so far so good
When I open the workbook up, I see all 6 images (2 x 3) and it launches the other workbook just fine
BUT - when I close that workbook or even just leave it open and go back to the first, 3 of the 4 images are gone - the block for it is still there - and I can click on that and jump to the workbook - but the image is gone - and it will alter based on the first of the 4 I select as to which 1 (or 2) will remain
Tried recalc - used the SHOW FORMULAS on the FORMULAS ribbon tab - done several times, and clicking on the Outline of the missing graphics - it eventually comes back and stays with no further issues
I would like to understand what is happening and possibly write a macro or code to eliminate it???????
In addition to the charts that are in the workbook -
I have several in another workbook (all sitting on sharepoint)
I did as before - and made sure the worksheet name was a part of the image name
I did a copy and when I pasted to my other workbook - it added the workbook name - so far so good
When I open the workbook up, I see all 6 images (2 x 3) and it launches the other workbook just fine
BUT - when I close that workbook or even just leave it open and go back to the first, 3 of the 4 images are gone - the block for it is still there - and I can click on that and jump to the workbook - but the image is gone - and it will alter based on the first of the 4 I select as to which 1 (or 2) will remain
Tried recalc - used the SHOW FORMULAS on the FORMULAS ribbon tab - done several times, and clicking on the Outline of the missing graphics - it eventually comes back and stays with no further issues
I would like to understand what is happening and possibly write a macro or code to eliminate it???????