Getting rid of update links popup?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi,
menu Tools > Options , tab Edit, uncheck the 'Ask to update automatic links'.
 
Thanks for the reply. Unfortunately, I'm the developer, not the user. Due
to multiple reasons, I cannot ask the users to uncheck the box. I'd like to
find a way to ignore the box in programming so that the users do not need to
do anything. Is there a way?

Scott
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Faststone Image viewer popups! 2
Stop marco allert and update link allert when opening spreadsheet 1
Windows 10 Unexpected update 18
macro to email Excel file 1
Email "Revocation information for the Security Certificate is not available" popup problem. 0
skip popup window 1
Macro for Opening Reuters, Opening Excel File, Closing Excel File 2
Weird taskbar entry - how to get rid of it and its file? 1

Back
Top