from Microsoft :
“Don’t ask whether to update links when I open any workbook, and update links automatically
This option is for the current user only, and affects every workbook opened. Other users of the workbook are not affected. This option also affects links to other workbooks.”
Is there a way to make this option valid for all the users that open this shared workbook ? Without changing the Tools->Options->Edit->Ask to update Automatic links checkbox for each ?