I have 6 workbooks. 5 of the workbooks are password protected to read and
modify because they contain very confidential payroll info. The 6th document
is a rollup doc that's linked to the other 5, but doesn't need to be password
protected, because the numbers are an aggregate - no sensitivity required.
When users go into the 6th document, they are asked to input 5 passwords -
which is a huge pain in the butt - is there a way to bypass these passwords
(without having to "cancel" out) and still have the information update?
thank you, Jess @ Lifetime Fitness