Link to a password protected workbook

  • Thread starter Thread starter Bill Board
  • Start date Start date
B

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?
 
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.
 
Back
Top