Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
URGENT - Disable links in a shared workbook
I am using an excel sheet which is shared across a network. This
workbook has links to several workbooks. The workbook needs to remain shared & protected while its on the network. Sharing and protecting works fine. However, i have observed that when the workbook is shared and protected, the links can still be broken / updated. This should not be allowed. When the workbook is shared and protected, the users viewing the workbook should not be able to update or break the links. Is there an option in excel that i am overlooking that does not allow users to update links in a shared workbook? Please assist. |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
URGENT - Disable links in a shared workbook
Hi Arlette,
You would need to do something like this in addition to protecting the speadsheet: 1. Put the workbook in Manual recalculation mode 2. Disable the Edit Links command 3. Disable the F9 and related recalculation keys 4. Disable access to the Tools, Options command. You would need to do this via VBA if it can be done at all, and I'm not sure all of these can be disabled. It might be easier to create a "user" copy of the file in which you convert all the formulas to values. Cheers, Shane "Arlette" wrote in message ... I am using an excel sheet which is shared across a network. This workbook has links to several workbooks. The workbook needs to remain shared & protected while its on the network. Sharing and protecting works fine. However, i have observed that when the workbook is shared and protected, the links can still be broken / updated. This should not be allowed. When the workbook is shared and protected, the users viewing the workbook should not be able to update or break the links. Is there an option in excel that i am overlooking that does not allow users to update links in a shared workbook? Please assist. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent!!! Disable Sharing (File on FTP) | Excel Discussion (Misc queries) | |||
Can you disable the save function from a shared workbook | Excel Discussion (Misc queries) | |||
Links not updating in shared workbook | Excel Worksheet Functions | |||
Shared Workbook Problem, Urgent | Excel Discussion (Misc queries) | |||
URGENT!!! shared workbook | New Users to Excel |