I have two documents. Document A pulls data from document B. Both must be
password protected and have the same password. When I open document A, enter
its password, and tell it to update from document B I then have to enter the
password from document B.

Is there any way to make entering the password for document A satisfy the
need to enter the password for document B?