link a picture

[Khalil Handal]

Hi ,

I have four different workbooks, each workbook has different sheets, some of the sheets in these workbooks have pictures.
I need to change one particular picture in some of the sheets in these different workbooks. Is it possible not to do this manually?
Is it possible to the photo in a specific folder so that I just give the new photo the same name as the current one in the folder so it will automatically be replaced in all the sheets?

Khalil

[iLoveMaggi]

hello there khalil....
can you attach an example workbook for better reference because its hard to interpret what you want

[Khalil Handal]

Hi again,
Book1 has three sheets: Sheet1, Sheet2, Sheet3
Book2 has two sheets: Sheet1, Sheet2
I have a photo (Logo1) in the same folder with Book1 and Book2.

Sheet2 and Sheet3 of Book1, and Sheet2 in Book2 has the same photo named (Logo1).

What I want is to change the photo (logo1) with a different picture.
So, I delete Logo1 then I rename a second picture using the name Logo1.
The result should be seeing a different picture in the four sheets mentioned above.

Khalil

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook.