Protecting/managing links from my worksheet

G

GWilson

Using Excel 2003. I have a complicated workbook that has a lot of links. Is
there a way to know what other workbooks (from other networked users) are
using data from my workbook through the link function?
 
J

Jim Thomlinson

In short... Nope. You can see what workbooks the spreadsheet is linked to but
you can not see which workbooks link to the spreadsheet you are in. Yet one
more reason that I never link workbooks. In fairness I did successfuly link
one set of template workbooks to pull data from a master data repository
workbook. That being said I locked things down to the nth degree. Only a
small set of users could access the master repository workbook and even then
I only gave them ashortcut to the master so that they could not accidentally
delete or move the book.
 
Top