VBA Code to prevent word document trying to open links at opening

[John Pryor]

Hi There,


I am new here. I am pulling together a report template for my work, which encompasses around 200 links to an excel source documents.
Notwithstanding that I have unticked the relevant box in the File/Options menu, frustratingly, the document still attempts to update links. All links are set to 'manual'.

The document will be opened by different users, some of whom will not have access to the excel, so wont be able to have the excel open first. As such, I wondered if some form of Document Open VBA code might work as an alternative workaround?

Appreciate any guidance.

Cheers,
John