In Excel 2007 I have five workbooks that are linked to a 6th workbook. Each
of the 5 workbooks is password protected to open. When I open the 6th
workbook, Excel requests that I provide the password of each of the 5
workbooks so the links will update, Is there a way around that.