Questions

Answer for:

Excel 03/07 link picture from one workbook to another

Message 4 of 4

View entire thread
+
0 Votes
lay98

You can do the following
a. the work sheet having the picture to be referred to (Worksheet 1)
click at the cell having a picture
Edit -> copy

b. The work sheet going to have the referenced picture (Worksheet 2)
clcik at the cell going to have the referenced picture
hold <Shift> key, then Edit->paste picture Link

so when there is update of the picutre in worksheet1, the changes will be reflected in work sheet2

Details please use the excel help on the Create a picture from cells, a chart, or an object topic