I have a workbook that is shared between 15 people in one department. I don't
know what I did wrong when I set it up. It is our archaic method of
scheduling in between the creation of an access database. Each person has
their own sheet. They do not ever change anything on anyone else's sheet.
Here's the problem; Say Person A and Person B have the file open, A doesn't
make any changes on her sheet and leave the file open, meanwhile B opens the
file and starts making changes saves and closes the file. Several hours go by
and A decides to make changes on her sheet, then saves and closes. When B
opens the file again, all changes are gone... What did I do, why is the file
not updating the workbook simultaneously. I can understand if they were
making changes to the same cells, but they're not even making changes in the
same worksheet.