When I open a worksheet I get a popup asking if I'd like to update all linked
information. Is there a way I could program it so that they are
automatically updated and the popup does not occure?

I was able to put an event handler on open to update the linked information
but it still give the popup. If I choose yes, then the linked info is
updated twice.