Software

Ask something
Question Locked

Update links in excel

0 helpful
2 replies

by highlander718 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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 ?

2 replies

by highlander718

Do not display the alert and update links
If you select the option Don't display the alert and update links on a workbook, this choice affects all users of the workbook. However, this choice applies only to that particular workbook. If the person who opens the workbook has the Ask to update automatic links check box selected, the message appears. The users who set in the options page override the workbook setting.

This discussion is closed to new replies.