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?

--
neb
-----------------------------------------------------------------------
nebb's Profile: http://www.excelforum.com/member.php...nfo&userid=898
View this thread: http://www.excelforum.com/showthread.php?threadid=27348