| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
Excel not warning if another user has the workbook open
hi everyone,
Normally Excel will warn users on my network if another user has already opened the workbook that they are trying to open. There are two or three workbooks that Excel stopped warning the user's about other users having them opened. I have checked "Read Only Recommended" under Tools - Options - Security Tab, which has solved the problem, ie users once again receive the warning if someone else has already opened the file however they are now also warned when opening the file that they should preferably open the file as Read Only. How do I configure these workbooks to warn if they have been opened already but not when they are not? Any assistance would be much appreciated. eddiec :-) |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
|
Excel not warning if another user has the workbook open
Click Tools / Share Workbook... and check the "Allow changes..." button.
/i. "Edward Chalk" wrote in message ... hi everyone, Normally Excel will warn users on my network if another user has already opened the workbook that they are trying to open. There are two or three workbooks that Excel stopped warning the user's about other users having them opened. I have checked "Read Only Recommended" under Tools - Options - Security Tab, which has solved the problem, ie users once again receive the warning if someone else has already opened the file however they are now also warned when opening the file that they should preferably open the file as Read Only. How do I configure these workbooks to warn if they have been opened already but not when they are not? Any assistance would be much appreciated. eddiec :-) |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.setup
|
|||
|
|||
|
Excel not warning if another user has the workbook open
thank you,
Eddie "immanuel" wrote in message ... Click Tools / Share Workbook... and check the "Allow changes..." button. /i. "Edward Chalk" wrote in message ... hi everyone, Normally Excel will warn users on my network if another user has already opened the workbook that they are trying to open. There are two or three workbooks that Excel stopped warning the user's about other users having them opened. I have checked "Read Only Recommended" under Tools - Options - Security Tab, which has solved the problem, ie users once again receive the warning if someone else has already opened the file however they are now also warned when opening the file that they should preferably open the file as Read Only. How do I configure these workbooks to warn if they have been opened already but not when they are not? Any assistance would be much appreciated. eddiec :-) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Eliminate macro warning when you open a workbook | Excel Discussion (Misc queries) | |||
| Open Workbook to Protected/Read-only Warning | Excel Discussion (Misc queries) | |||
| Getting Warning when I try to open excel in 2007. | Excel Discussion (Misc queries) | |||
| Excel file already open warning | Setting up and Configuration of Excel | |||
| Why do I get a warning when I try to save an Excel 2003 workbook. | Excel Discussion (Misc queries) | |||
Linear Mode
