linking excel workshbooks

gordonfitch

New Member
Joined
Sep 17, 2006
Messages
5
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
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
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

New Member
Joined
Sep 17, 2006
Messages
5
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
 

Forum statistics

Threads
1,141,096
Messages
5,704,312
Members
421,338
Latest member
Pepess

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top