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.

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.