I have a worksheet (we'll call it totals.xlsx) that basically contains consolidated data from several other worksheets that are in different workbooks. The data in any given cell in totals.xls is calculated by adding the data in cells from several other workbooks (via external link)...i.e. my calculation looks something like this:

=657+'C:\Users\John\Documents\classcount\2007\[2007classcount.xlsx]SchoolX'!$G$2

Data is compiled annually so each year there is an additional cell added to this equation from a new workbook.

This works fine, but here is my problem...the workbook classcount.xlsx is password protected. My totals.xlsx worksheet references 8 other files (and this number increases annualy) that are all password protected and excel prompts me to enter the password for everyone of those files every time I open totals.xlsx. That's annoying when you have to type the same password 7 times every single time. I think in Excel 2003, there was a way to grant permanent access to password protected workbooks that were linked to externally, but either I'm remembering wrong, or this option is not available in excel 2007. Anybody know a way I can grant my totals.xlsx file access so I don't have to type the password every time??? Is this possible without writing a script??? Thanks for any help.