I have an Excel spreadsheet linked to a word document. I have the links set
to update automatically but they don't. It is my understanding that whenever
I change a value in the spreadsheet it should be automatically updated in the
linked field in the Word document, but it doesn't update 'till I click on
"update link", or when I open the Word document it gives me the option to
update links.

After further investigation, it has something to do with the formatting of a
particular word document that I am working with, which I copied from a
co-worker. When I open a new blank word document and link to it from excel,
the auto update works fine. But when I try to link to this particular
document (which I don't want to have to rebuild from scratch) the auto update
doesn't work. I've checked all the settings that I can think of, they all
seem to be correct.

"depawl" wrote:

> I have an Excel spreadsheet linked to a word document. I have the links set
> to update automatically but they don't. It is my understanding that whenever
> I change a value in the spreadsheet it should be automatically updated in the
> linked field in the Word document, but it doesn't update 'till I click on
> "update link", or when I open the Word document it gives me the option to
> update links.