Master document with links to other workbooks password issues. Excel 2013

[beeby]

So here is the issue.

I have one master document that pulls data from 12 other workbooks. Each workbook has a password. the master sheet has a password. All the passwords are the same. I will only ever have the master open and 1 of the workbooks at a time. Currently on my system excel asks me for the password 2 times. 1 for the master 1 for the other. My manager however, is asked for all 12 other sheets passwords every time she open the document. is there a setting that she may have on/off or i may on/off have on that is causing this?

 

[beeby]

So here is the issue.

I have one master document that pulls data from 12 other workbooks. Each workbook has a password. the master sheet has a password. All the passwords are the same. I will only ever have the master open and 1 of the workbooks at a time. Currently on my system excel asks me for the password 2 times. 1 for the master 1 for the other. My manager however, is asked for all 12 other sheets passwords every time she open the document. is there a setting that she may have on/off or i may on/off have on that is causing this?.