Automatic Updating of Links

[depawl]

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.

 

[depawl]

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.