Linking to External "Password Protected" Worksheet

D

dave1030

I am linking to a cell in a protected worksheet to retrieve the data in that
cell. The command I am using is ='D:\directory\[spreadsheet
name.xls]Actuals'!$F$369.
Is there a way that I can embed the password into this command so that the
pop-up window doesn't always appear and request the password be typed in?

Thanks, Dave
 
Top