Problem with file Links

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

Originally Posted by natefarm

You can code them into the macro, as long as your workbook containing the macro is secure.

Please Login or Register  to view this content.

In your code, do I assume correctly that the "yourfile.xlsx" code is the name of the file that my Company-Wide Budget file is reading data from the the "pwd" is password that my model is asking for on the source file? Assuming that's correct, if I have 16 department I can stack the code 16 adjacent rows high?

Thanks for your help.
RR

Does your code actually open all 16 of the source workbooks or just allow the consolidating budget workbook access the amounts and remain current? As well, when I open the consolidating budget workbook, it asks if I want to "Update" or "Don't Update". If I click "Don't Update" will all the cells the reference an external source workbook (all of which are on a network server) calculate with the current amounts?

Thanks,
RR

When I open the consolidating budget workbook, it asks if I want to "Update" or "Don't Update". If I click "Don't Update" will all the cells that reference an external source workbook (all of which are on a network server) calculate with the current amounts? In other words, when I click "Don't Update", it does not ask me for all the other passwords so if I do that, I get around having to input all the passwords but do all the formulae work properly?

Last question so I will stop bugging you. If I Don't Update, won't I have to ultimately enter all the passwords to get the data to refresh when I finally do hit F9? In which case leads me to try to input code to enter all the passwords so it will refresh without all the aggravation of have to input all the passwords.