ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Protecting/managing links from my worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/196767-protecting-managing-links-my-worksheet.html)

GWilson

Protecting/managing links from my worksheet
 
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?

Jim Thomlinson

Protecting/managing links from my worksheet
 
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.
--
HTH...

Jim Thomlinson


"GWilson" wrote:

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?



All times are GMT +1. The time now is 10:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com