password protected workbooks with links between them

  • Thread starter Thread starter Dez
  • Start date Start date
D

Dez

Hi, hope someone can help me. I was using Office 2000 and started using
Office 2003 recently and have since encountered this problem with Excel:
I have workbooks which are password protected that contain links to each
other. My settings are: Edit> Links> Update> Automatic ; Update Remote
References box is ticked. My problem is that even though password protected
workbooks are open at the same time, if I capture data into the source
workbook, the resulting data does not automatically update in the destination
workbook, and also, if I want to edit a formula containing a link, in either
workbook, it asks for the password of the open workbook. I didn't have this
problem in Office 2000 and don't know how to get around it!
Please someone help me...
Thanks
 
I have had a similar issue. In my case it was due to linking files
over various network drives. The way I fixed it was to open both
workbooks... then in the workbook with the links to the password
protected workbook, go to Edit-> Links.

Click on the password protected workbook and click change source.
Find the password protected file and click ok.

see if that helps
 
Thank you so much! Yes, linking files over various network drives was exactly
the cause of my problem!
 
Back
Top