linking excel workshbooks

[gordonfitch]

Can anyone help with this question?

I have an excel spreadsheet which I need to be protected by a code or password. whilst I am familier with using password protection, I would like to be able to have the main workbook connected to a remote workbook by a link.

This link should be situated in another workbook. The idea is that if one or other of the workbooks are deleted and the link broken, then the main workbook should become useless.

Any ideas please - I have spent the last 13hrs playing with all sorts of formula combination and I've hit a brick wall.. Thanks Gordon

 

[shajueasow]

Not sure of your need but still.
Assume that there are three books Book1 - Your master record,
Book2 - your remote book, and Book3 - your "link".
In master workbook enter formulas with reference to your Book3, and in book 3 enter formulas refering to Book2. So if either Book 2 or Book 3 is deleted then Book1 will be of no use.
HTH

 

[gordonfitch]

Hello HTH

Thanks for the reply - to clarify, I need the ability to be able to render a workbook un-usable (ie if the contents become out-dated).

I did try to use a separate workbook in which I placed the formula which was essential in the master workbook to make the whole book work, but because I had placed this formula in another workbook and used a =sum(('C:\Reports\[Remote_Formula.xls]Formula_Sheet'!C5)

For example,whilst the master workbook worked, the cell in which I had placed the link to the remote worksheet failed to display the correct information.

I will try your suggestion; the use of a third worksheet could work. Thanks again - Gordon