I have company-wide budget model that pulls department budget from each of their password protected files. When I open the company-wide budget model, it asks me to "Update" or "Don't Update", if I click Update, it asks me for the password for all 16 department passwords. That's a pain.

My question is if I click "Don't Update", and work for now, the first time I calculate the model, will it ask me for all the passwords? In other words, do I either have to enter all 16 passwords at some point manually or put them all in a macro?

Thanks,
RR