I have multiple users that need to access the same worksheet. I understand
Excel supports shared workbooks/worksheets but don't know anything about how
it works other than it puts multiple entries in as Tracked Changes.

My users need to add information to the 1st empty row of the sheet. If 2
users do this at the same time, they would both being trying to enter
information into the same row.

If Excel puts them in as Tracked Changes, how would it handle this conflict
when I try to accept the changes? Would I only be able to accept one,
negating the other(s)? Or will it know to paste the additional changes on the
next available row?

If it won't allow me to accept them all, how can I work around this ?

Thanks,
--
JoAnn