Thank you for solving my "Turning off the prompt to refresh automatic links".
This was driving me CRAZY.

Could you help me with another problem? Once I click on a hyperlink I keep
getting asked "Some files may contain a virus do I still want to open this
File"? My answer is always going to be yes.

Andy




"Ron Coderre" wrote:

1: Turning off the prompt to refresh automatic links

From the Excel main menu:
<tools<options<edit tab
UNcheck: Ask to update automatic links

2: Engage macros without asking
Now wouldn't that competely undermine the whole purpose of prompting the
user that's intended to prevent malicious code from running automatically?

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Peter" wrote:

When my workbook is linked to another, Excel always asks if I want to update
the link upon opening the workbook. Can I turn off this question, so Excel
always updates without asking? In the same way can I stop it asking about
enabling macros when I open a work book conatining a macro, so that the macro
is alway enabled without asking. Many thanks.
--
Peter
London, UK