You can do this with a workbook_open event in the control file. Since there
are links to all 50 in the control file, "Ask to update automatic links" is
off, it will want to open all 50 workbooks.

I believe Mr. Ogilvy gave you the best answer:

In tools=Options=Edit tab, make sure "Ask to update automatic links"
is
checked.

Since this is a control file, I presume you are opening it to make changes.
When you open it with Mr. Ogilvy's method, it temporarily stops updating the
links. Make the changes to the control file, save, and close the control
file. When the users open their workbooks, the links will refresh in their
workbooks. So why bother opening all 50 files.

Regards,

Alan



"0o0o0o0o" wrote in message
...
I have 50 password-protected workbooks (time sheets) and a control file.
Each
employee has his own file with unique password, supervisor is the only one
who can access control file and enter information that is compared to data
from individual time sheets and flags any errors. The problem I have is
when
I open control file, it tries to access individual time sheets to get
data,
and since every time sheet file is password protected, I have to enter 50
passwords. Is there any way around this? Note: every time sheet must be
password protected - privacy concerns.
Any help on this would be greatly appreciated.