Edit, Links, Startup Prompt may help (Excel 2002-2003). Data tab,
Connections, Edit Links in Excel 2007.

--
Jim
"Chuck M" wrote in message
...
|I need some expert help on this one....
|
| I have 2 workbooks with links to each other. (ie some cells in Workbook
'A'
| link to Workbook 'B' and some cells in Workbook 'B' link to Workbook 'A').
| Both workbooks need passwords to open them. On open of Workbook 'A', I do
not
| want the user to be prompted to update the links from Workbook 'B' but I
want
| the links to be updated.
|
| I hope this in enough detail to go on. Any help will be greately
appreciated.
| --
| Thanks.
| Chuck M.