[Jim Ransford]

I have an Access VBA function that posts data to an Excel spreadsheet. That
data is linked to Word documents. When the Word documents are printed, the
current data from the spreadsheet should be in the document.

This worked successfully for several years beginning with Office 97 through
Office 2003. At some point (maybe late last year) the links stopped being
updated automatically. All my settings are correct, the links are set to
update automatically.

In fact, a prompt now comes up to ask if the links should be updated when
the document is opended. Clicking OK does nothing. The links do not update.

I seem to remember reading someplace that this was a security issue and
either XP or Office has been updated to prevent automatic links from working.
(I did find something that acknowledged this issue and gave a registry hack
that at least prevented the now meaningless dialog prompt to update the
links. But it did not solve the bigger problem.)

How can I get this functionality back? We use this several times every day
and manually updating the links is very time consuming.