I have seen several posts here regarding data loss associated with shared
workbooks. I have not read any reponses that have satisfied my personal
curiosity. Please post here if you are either personally experiancing this
problem or if possible you actually have a solution to the problem.

Description of my problem: We have one shared workbook on a network drive
that is constantly beiong updated by multiple employees. We have had 3-4
people in the last few days indicate that data they had entered and saved is
now now missing.

We have since turned on data tracking but have not found any useful
information to determine what the problem is.

Does Microsoft acknowledge that it is possible for users editing data in the
same field at the same time can overwrite each others data?

On Nov 16, 5:02 pm, mi1stormilst
wrote:
I have seen several posts here regardingdatalossassociated with sharedworkbooks. I have not read any reponses that have satisfied my personal
curiosity. Please post here if you are either personally experiancing this
problem or if possible you actually have a solution to the problem.

Description of my problem: We have one shared workbook on a network drive
that is constantly beiong updated by multiple employees. We have had 3-4
people in the last few days indicate thatdatathey had entered and saved is
now now missing.

We have since turned ondatatracking but have not found any useful
information to determine what the problem is.

Does Microsoft acknowledge that it is possible for users editingdatain the
same field at the same time can overwrite each othersdata?

This also happen to me today. I am not sure what caused it.

From Help on shared workbooks.............

Resolving conflicts When you save changes to a shared workbook, another
person who's currently editing the workbook might have saved changes to the same
cells. In this case, the changes conflict, and a conflict resolution dialog box
appears that allows you to decide whose changes to keep.

........................

Perhaps users are ignoring this and saving just their own changes?


Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 09:18:06 -0800 (PST), wrote:

Does Microsoft acknowledge that it is possible for users editingdatain the
same field at the same time can overwrite each othersdata?

No, the users experiancing the loss are not being prompted and we have at
least two documented cases where the last user to make changes did not get
prompted for conflicts. I assume this means that no conflict existed? Anyway,
I think the other possibility is that since there is no real security
attached to the file anyone could save a local copy and then save over the
shared copy. The will not show up in Track Changes either )-:

"Gord Dibben" wrote:

From Help on shared workbooks.............

Resolving conflicts When you save changes to a shared workbook, another
person who's currently editing the workbook might have saved changes to the same
cells. In this case, the changes conflict, and a conflict resolution dialog box
appears that allows you to decide whose changes to keep.

........................

Perhaps users are ignoring this and saving just their own changes?


Gord Dibben MS Excel MVP

On Wed, 28 Nov 2007 09:18:06 -0800 (PST), wrote:

Does Microsoft acknowledge that it is possible for users editingdatain the
same field at the same time can overwrite each othersdata?