J
justanormalguy
I have a shared workbook that typically has 3-5 users sharing. Once or
twice a week someone complains eithor that information shows up in a
row that no one entered, or the information they did enter has been
changed and is incorrect. Checking with other users confirms that no
one changed the information. Using "Highlight Changes", it will show a
user made a change, but from talking with the users it is clear the user
did not make the change. Often it is clear the information "moved" from
above or below the cell in the same column. Column sorts are not being
performed and are not the problem.
Today my boss said he had an incident where he made an entry and came
back the next day and a different date was in the cell. He looked at
other people's computers in the office and it was correct on their
machine. So his machine on the shared workbook was the only machine
that showed incorrect information. He closed Excel and reopened the
shared workbook, and the date that had been incorrect magically
corrected itself.
What happens is that when the workbook is in this "incorrect" state,
entries and edits are recorded in rows other than what the viewer is
looking at, so that when the "incorrect" state is saved, other users
with the "correct" state will have entries in wrong rows.
The users use filters a lot but hardly ever sort. For new lines they
insert a blank row between other rows. I've looked at the problem of
duplicate "phantom" users showing up in the shared user list and wrote
a macro that gets rid of any phantom users if they exist. I'm thinking
it may have something to do with the custom (personal) view that always
gets created for each shared user, but turning off the view filter
settings makes no difference. Unsharing and sharing again seems to
make no difference.
I am communicating with another person who has had this problem for
over a year, so I know I am not the only one. Any ideas anyone? If I
could just duplicate the problem I could find the solution.
Bert
twice a week someone complains eithor that information shows up in a
row that no one entered, or the information they did enter has been
changed and is incorrect. Checking with other users confirms that no
one changed the information. Using "Highlight Changes", it will show a
user made a change, but from talking with the users it is clear the user
did not make the change. Often it is clear the information "moved" from
above or below the cell in the same column. Column sorts are not being
performed and are not the problem.
Today my boss said he had an incident where he made an entry and came
back the next day and a different date was in the cell. He looked at
other people's computers in the office and it was correct on their
machine. So his machine on the shared workbook was the only machine
that showed incorrect information. He closed Excel and reopened the
shared workbook, and the date that had been incorrect magically
corrected itself.
What happens is that when the workbook is in this "incorrect" state,
entries and edits are recorded in rows other than what the viewer is
looking at, so that when the "incorrect" state is saved, other users
with the "correct" state will have entries in wrong rows.
The users use filters a lot but hardly ever sort. For new lines they
insert a blank row between other rows. I've looked at the problem of
duplicate "phantom" users showing up in the shared user list and wrote
a macro that gets rid of any phantom users if they exist. I'm thinking
it may have something to do with the custom (personal) view that always
gets created for each shared user, but turning off the view filter
settings makes no difference. Unsharing and sharing again seems to
make no difference.
I am communicating with another person who has had this problem for
over a year, so I know I am not the only one. Any ideas anyone? If I
could just duplicate the problem I could find the solution.
Bert