How to enable macro and updated link without confirmation?

[Eric]

Does anyone have any suggestions on how to enable macro and updated links
automatically without pop up any window for confirmation?
Therefore, I don't need to click twice for opening a worksheet.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric

 

[Sheeloo]

Excel 2003
Tools->Options->Edit Tab
Clear the check box 'Ask to update automatic links'

Tools->Options->Security Tab->'Macro Security' button
Select 'Low' radio button

Be aware that these settings make you vulnerable to macro based threats...