Hi there,

I have seen quite a few posts on this and know it is "easily"
accomplished, however I have a bit of a different requirement.

I have a Word document that I have embedded the following:

- 1 Sheet that holds score data that users can edit within word

- 6 Graphs (from the same workbook) that report the data in different
ways.

What I want to happen is that when the data in the embedded worksheet
is edited, then all the other graphs update to reflect the edited data
or scores.

Any ideas ? I have one, which is to cycle through each embedded chart
and copy the data scores from the embedded sheet to the relevant sheet
that the chart is linked to - but is there another way ?


Also as an aside - Is there a way to rename the objects ? Rather than
the arbitarily named 'ActiveDocument.Shapes("Object 3").Select' This
is a problem if you ever have to delete an then add embedded objects

Thanks in advance

Jason