Linked Workbooks + Password Protect

[babyhime4]

The Skinny:
I am trying to put together a budget planner for my company where each division has the option to give a part of their allotment to each other. I need each division's workbook to have the latest update from the others:

Division1 - gives $500 to both Division2 and Division3
Division2 - gives $200 to Division1

So when each division opens their workbook they will see how much more or less their budget has changed.

The Problem:
I have Division workbooks linked to a Master workbook. A Division "talks" to the Master, then the Master turns around and updates all the Divisions. Problem is, I get #VALUE! errors for every link UNLESS I physically open each workbook. Added twist - they all need to be password protected.

The Question(s):
Am I able to do what needs to be done in the described scenario with as little as possible or no use of VBA at all? Any suggestions?

 

[PapaSmurf]

What formula is giving the error?
Some formulas dont work to closed workbooks, I suspect the one your using is one of them. If you post it I'l suggest something else in it's place.

 

[babyhime4]

Thank you papa smurf but I no longer need this workbook. The end users decided it would be best to keep things as simple as possible so linked workbooks was taken off the table. Have a great one!

 

[PapaSmurf]

Good luck with the rest of it.