Link to a password protected workbook
 

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?

Link to a password protected workbook
 

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.



Bill Board wrote:

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