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