Link to a password protected workbook

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?
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Password protect new workbooks from template 0
Excel - different figures returned?! 0
How do I link a cell in a workbook? 1
How to create absolue path link to another workbook (Excel 2003) 1
update links to password protected workbooks. 1
password protected workbooks with links between them 2
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
Linking Password workbooks 1

Top