Excel sheet embedded into word - changes not reflected in word
Hi, I embedded an xl worksheet into a word doc by linking.
At that point in time, when I have both the word doc and xl doc open, if I change values in xl, they change in word. This is what I want.
However, if I close the xl doc and then reopen the xl doc and then change the values in the xl doc, there is no corresponding change in the word doc.
I am pretty sure I have linked them correctly, just looks like the link fails when I close and reopen the xls.
Both the xls and word doc are stored in SharePoint.
Any ideas?
Thanks Andrew
|