| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with multiple users opening a workbook
We have a workbook in 97-2003 format, the problem is that 2 users are able to
open and make changes to the workbook even though it is not shared out. What we require is that if one person opens it then the second will get the message that it is open and to open it as read only but this is not happening. One user is using excel 2003 and the other is 2007 I don't know if this makes any differnece. I have tried saving as html and the saving back as a workbook but this has had no effect. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem with multiple users opening a workbook
If they are set to make local copy to edit, you could have issues like that.
Dazza13 wrote: We have a workbook in 97-2003 format, the problem is that 2 users are able to open and make changes to the workbook even though it is not shared out. What we require is that if one person opens it then the second will get the message that it is open and to open it as read only but this is not happening. One user is using excel 2003 and the other is 2007 I don't know if this makes any differnece. I have tried saving as html and the saving back as a workbook but this has had no effect. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem with multiple users opening a workbook
They both open the same copy on the network i'm not sure what you mean by set
to edit the local copy? "Bob I" wrote: If they are set to make local copy to edit, you could have issues like that. Dazza13 wrote: We have a workbook in 97-2003 format, the problem is that 2 users are able to open and make changes to the workbook even though it is not shared out. What we require is that if one person opens it then the second will get the message that it is open and to open it as read only but this is not happening. One user is using excel 2003 and the other is 2007 I don't know if this makes any differnece. I have tried saving as html and the saving back as a workbook but this has had no effect. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Problem with multiple users opening a workbook
Sorry, I was remembering a setting in Word 2007. "Copy remotely stored
files onto your computer and update the remote file when saving" Dazza13 wrote: They both open the same copy on the network i'm not sure what you mean by set to edit the local copy? "Bob I" wrote: If they are set to make local copy to edit, you could have issues like that. Dazza13 wrote: We have a workbook in 97-2003 format, the problem is that 2 users are able to open and make changes to the workbook even though it is not shared out. What we require is that if one person opens it then the second will get the message that it is open and to open it as read only but this is not happening. One user is using excel 2003 and the other is 2007 I don't know if this makes any differnece. I have tried saving as html and the saving back as a workbook but this has had no effect. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limiting number of users opening Excel Workbook at one time. | Excel Discussion (Misc queries) | |||
| Long delay opening a workbook through our Intranet for some users | Links and Linking in Excel | |||
| Multiple users workbook? | Excel Discussion (Misc queries) | |||
| Multiple users opening same Excel spreadsheet. | Excel Discussion (Misc queries) | |||
| Multiple users in one workbook? | New Users to Excel | |||
Hybrid Mode
