Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making changes to the same worksheet by two users at the same time
I would like to keep changes made to the same worksheet by two different
users at the same time. I have tried sharing options and merging but couldn't get it right - changes by one user are overwritten by the other. I want all the changes by all users to be reflected. I work with Excel 2002. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making changes to the same worksheet by two users at the same time
If you share a file, you are always liable to one user overwriting the
other. That can happen if they are working at the same time, or two very different times. The latter is unavoidable, even if you use a proper database, but the former can be avoided by design, whenever someone retrieves a data item (In Excel I guess this would be just selecting a data row), you set a flag, and if anyone else tries to write back that row it would error. When the original user writes it back or moves on, release the flag. A lot of effort, not foolproof, and not worth the bother IMO. I would just stop it being a shared workbook, then the second user would only be able to read it. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "Monika Graczyk" <Monika wrote in message ... I would like to keep changes made to the same worksheet by two different users at the same time. I have tried sharing options and merging but couldn't get it right - changes by one user are overwritten by the other. I want all the changes by all users to be reflected. I work with Excel 2002. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
MAKING A CONTRACT FROM DATA FROM A WORKSHEET | Excel Worksheet Functions | |||
Excel workbook to be used by multiple users at same time....possible??? | Excel Worksheet Functions | |||
How do I open to a specific worksheet every time? | New Users to Excel |