I have a problem similar to the user who posted the thread "Macro to update links when the source workbooks are password protected". However, I am not using a macro. I have a summary worksheet with cells that reference a number of password protected worksheets.

If I open the referenced worksheets ahead of time, with the password (and for some of the worksheets I am prompted twice for the password), the references work fine.

If I don't, then I am prompted for 1 or 2 passwords for each worksheet name unique cell reference.

I took the following code to open the worksheets from the thread "Macro to update links when the source workbooks are password protected" and placed it in (General), but am obviously missing something.

code
Sub Update_Links()
Application.Workbooks.Open Filename:="drivename:\filename1.xlsx", Password:="pwd"
Application.Workbooks.Open Filename:="drivename:\filename2.xlsx", Password:="pwd"
Application.Workbooks.Open Filename:="drivename:\filename3.xlsx", Password:="pwd"
End Sub
/code

Any assistance would be appreciated!