auto link update

[nebb]

Some of the formulas in one of my workbooks (say workbook A) reference
cell in another workbook (workbook B). Each time workbook A is opened,
window opens with the following:

"The workbook you opened contains automatic links t
information in another workbook. Do you want to update this workboo
with changes made to the other workbook?
To update all linked information, click YES
To keep the existing information, click NO"

If workbook B is not open when workbook A is opened is there a way t
automatically update workbook A with all linked information fro
workbook B, without having this window show up?

 

[Myrna Larson]

I went to help and typed "update links" in the search box. This is the first
hit:

Control the startup prompt for updating links

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 programs.

On the Tools menu, click Options, and then click the Edit tab.
Clear the Ask to update automatic links check box. If the box is cleared, the
links are automatically updated, and no prompt is displayed.

Don't ask to update links for this workbook, and let me control whether links
are updated

Warning This option affects all users of the workbook. If you choose to not
update links, and not to prompt, users of the workbook will not know the data
is out of date.

On Edit menu, click Links.
Click Startup Prompt.
Select the option you want.
Note You will still be notified if there are any broken links.