Tom
I have a similar situation that links to 50 password protected files, but
the summary file always asks for the password. do you have a sample macro for
the summary file to update the summary file from the 50 protected files. It
would be greatly appreciated.

I have the tools set up the way you suggest and the update link startup set
correctly.




--
Steve D


"Tom Ogilvy" wrote:

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

This is an Application level setting

In the workbook itself, if you are using Excel 2002 or later then under
edit=Links, click the startup button at the bottom and make the appropriate
selection.

--
Regards,
Tom Ogilvy


"0o0o0o0o" wrote in message
...
Thanks for answering. I don't have a macro written to pull data from data
sheets, it's just a cell reference from time sheets, and then data is
compared to values from control file. How would macro for passwords look
like, and is there any way to have those passwords stored in one of the
worksheets within control file so it's easy to lookup and change. Person
accessing control file doesn't know much about Excel.
Thanks again

"JLGWhiz" wrote:


Since you state that the control files begins to access the time sheets,
I
assume you have a macro set up that initiates the action. Add a code
snippet
to the macro that automatically provides the password to access the file,
and
make sure to close the file once the information is retrieved/reconciled.

"0o0o0o0o" wrote:

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.