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.