If an employee copies a workbook off of the server, can it be unusable because it cannot find its data links? Is there a setting to make this work? Is it possible to use data links from one cell to another to provide some sort of security? - I know a savvy user can find and copy the linked file also but our users are not that savvy.
If needed here is an example...
I have cells in Workbook 1 linked to cells in another workbook called Workbook A.
Wookbook A is stored in a folder on our server so every user who opens Workbook 1 with access to the server is able to get and the see the information linked from Workbook A.
If workbook 1 is copied or moved from our server to an unknown location that does not have access to Wookbook A (on our server), I would like the links to be broken and not visible or usable. - Is this possible?
If there is another way to do this or it is impossible, and it has been discussed in an existing thread, please let me know. Thanks.
If needed here is an example...
I have cells in Workbook 1 linked to cells in another workbook called Workbook A.
Wookbook A is stored in a folder on our server so every user who opens Workbook 1 with access to the server is able to get and the see the information linked from Workbook A.
If workbook 1 is copied or moved from our server to an unknown location that does not have access to Wookbook A (on our server), I would like the links to be broken and not visible or usable. - Is this possible?
If there is another way to do this or it is impossible, and it has been discussed in an existing thread, please let me know. Thanks.