I am trying to write a macro that will open all sources of external links to
my document, save the document & then close all sources again.
I have been able to do this but as soon as i add a new link the macro does
not pick it up.
Note: simply updating links does not work as each sheet has many items
calculated off the current date & so each day they are opened they change.

Any ideas? or do i need to do it manually?