Originally posted by mhabib
You could do try opening the linked files in your macro. In that case the passwords could be included in the OPEN commands. Since the linked files would already be open, the user will not be required to provide the passwords for updating the links.
there is no macro though.. it is just a cell formula that says =+G:\budgets\blah\blah.xls
but when the workbook is open it want's to update.. which I want.. I just don't want to be required to enter the pass..
maybe i am not following...