Link to a password protected workbook

[Bill Board]

I'm using Excel 2007. I have a workbook that links in numbers from other
workbooks. Everthing works fine until I put an open password on the
workbooks I have links to. How do I link to these workbooks when they have
a password?

 

[Dave Peterson]

Create your formulas the same way.

The only difference is that excel will prompt you with a password when it thinks
it has to recalculate that cell.

If you can't live with that prompt (those prompts???), then you can make sure
all the "sending" workbooks are open.