-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
EXCEL PROBLEM - NEED HELP
- Thread starter VQCHEESE
- Start date
Excelenator
Board Regular
- Joined
- Jul 30, 2006
- Messages
- 154
BECAUSE its a SHARED workbook BOTH users can WRITE changes to it so you would NOT get the "Read Only" message.
Upvote
0
Egress1
Active Member
- Joined
- Mar 2, 2003
- Messages
- 420
Another possibility that can happen in a network environment.... one of the users saves the file to a local location. And yet another is when a client is set up to work on a file "Offline" so to speak then sync the file at a later time when they are "Online" or networked. Yet another possibility is if there is an open event macro running that turns off that alert message.
Best thing to do is check to make sure that the file being worked on is the one and only file. So when you have a second user open a file and does not get that "Open for Read Only" question check to insure that the file they just opened is indeed in the right place and not a duplicate somewhere else.
Upvote
0
I guess that the spreadsheet isnt shared. Its on a network but not shared.
The promlem is:
One user was using it on Win2000, another User was using it on XP Professional. When the 2000 user had it open, and the XP user opened it and got no read only message...
The promlem is:
One user was using it on Win2000, another User was using it on XP Professional. When the 2000 user had it open, and the XP user opened it and got no read only message...
Upvote
0
Egress1
Active Member
- Joined
- Mar 2, 2003
- Messages
- 420
VQCHEESE,
We are talking about two different types of shares here. A shared workbook does not necessarily need to have shared access over a network. A network share which is what I assume you are talking about and as such asking the original question is what I am referring to.
Again....open up that workbook on one machine. Then go open it on the other machine and check the location of the file opened. My bet is that one of the machines is grabbing a duplicate file that has been saved to a different location on your network or to the local computer.
hth
-Ken
We are talking about two different types of shares here. A shared workbook does not necessarily need to have shared access over a network. A network share which is what I assume you are talking about and as such asking the original question is what I am referring to.
Again....open up that workbook on one machine. Then go open it on the other machine and check the location of the file opened. My bet is that one of the machines is grabbing a duplicate file that has been saved to a different location on your network or to the local computer.
hth
-Ken
Upvote
0
mark hansen
Well-known Member
- Joined
- Mar 6, 2006
- Messages
- 534
- Office Version
- 2016
- Platform
- Windows
Hold on... I'm reading through these posts during my lunch to glean as much as I can from you guys...
Are you saying that Excel can allow two (or more) people to pick up the very same Excel file (on the network) at the same time and both write data to that file. When both users save their data, additions/edits from both users will be in the file?
How do you do this... how does excel handle this? Am I reading this right?
Are you saying that Excel can allow two (or more) people to pick up the very same Excel file (on the network) at the same time and both write data to that file. When both users save their data, additions/edits from both users will be in the file?
How do you do this... how does excel handle this? Am I reading this right?
Upvote
0
Egress1
Active Member
- Joined
- Mar 2, 2003
- Messages
- 420
mark,
No there is some confusion as to what is being referred to as a shared workbook. Shared access to a workbook over a network is what I believe the OP was referring to in the original post.
You can set the behavior of a workbook to allow simultaneous changes and follow certain rules as to what to do about conflicting changes etc but someone else will need to explain that one for you.
No there is some confusion as to what is being referred to as a shared workbook. Shared access to a workbook over a network is what I believe the OP was referring to in the original post.
You can set the behavior of a workbook to allow simultaneous changes and follow certain rules as to what to do about conflicting changes etc but someone else will need to explain that one for you.
Upvote
0
Im having trouble here understanding. The workbook is out on a network drive and isnt not shared throught excel, although numerous ppl are accessing it on the network drive here at my company. Person A has it opened, and Person B didnt realize it, but opened it and started to edit it, and then didnt realize it was opened by Person A. Person B saved his changes and thought it was fine. When Person A opened it up from being minimized and finished her editing and saved, then she got the overwrite message saying do u wanna overwrite the new changes....She over wrote the changes and then Person B lost the stuff he changed....any help please...
DOES THAT CLARIFY ANYTHING MORE???
DOES THAT CLARIFY ANYTHING MORE???
Upvote
0
Egress1
Active Member
- Joined
- Mar 2, 2003
- Messages
- 420
vq,
Perfectly... it sounds as Excelenator said earlier that you have that workbook as a shared workbook in excel. You can verify this by going to the top menu item [TOOLS] and select [SHARE WORKBOOK] then make sure the "allow changes by more than one user at the same time" box is unchecked.
HTH
Perfectly... it sounds as Excelenator said earlier that you have that workbook as a shared workbook in excel. You can verify this by going to the top menu item [TOOLS] and select [SHARE WORKBOOK] then make sure the "allow changes by more than one user at the same time" box is unchecked.
HTH
Upvote
0
Similar threads
- Question
