Sharing workbook

I am not that familair with sharing a workbook. As of now a coworker has a workbook that is posted on a common drive. Initailly the entire workbook was posted as one, but only one person could make a change at a time. So, then they broke it up into 10 departments hoping that would help. Still the same problems.

Any suggestions on how to handle this better?

Basically, we have 40 units that go out and do simple inspections. Then come back and input data into the shared document. Then those are brought together and sorted into a master list.

I personally don't think the shared document is very efficient, but they seem bent on doing it this way, so trying to help out.

Thanks

Ok, that is kinda what I was thinking.

I appreciate the comment.

Brent