Why doesn't Excel save everything?
 

I am working with a large Excel file (over 2000 lines and 20 columns)
that is shared by at least five users in different offices who are
likely running different versions of Excel. We are frustrated by the
fact that it often seems like saved data is missing. For example,
when the file is opened, it often appears as though cells in one of
the columns were not saved while data entered into another column at
the same time saved successfully.

What could be causing this? Is there a remedy?

Thank you.

Why doesn't Excel save everything?
 

When two or more users are working on a shared workbook at the same time
conflicts can arise.

When this occurs one of the users has to be the lead and say which input is to
be saved.

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."

Is this not happening?


Gord Dibben MS Excel MVP

On Mon, 24 Sep 2007 08:04:59 -0700, wrote:

I am working with a large Excel file (over 2000 lines and 20 columns)
that is shared by at least five users in different offices who are
likely running different versions of Excel. We are frustrated by the
fact that it often seems like saved data is missing. For example,
when the file is opened, it often appears as though cells in one of
the columns were not saved while data entered into another column at
the same time saved successfully.

What could be causing this? Is there a remedy?

Thank you.