Shared Workbook

[robzrob]

5 of us are using a shared workbook. We all enter data in columns in
the next empty row, eg one entry consists of typing data into C10,
D10, E10, F10, G10 & H10. If user 1 & 2 both happen to be typing in
stuff on (say) row 10 and user 1 saves and then user 2 saves, user 2's
data overwites user 1's and user 1's data is lost.

Also I'm using a circular reference,
IF(C10="",""IF(B10="",NOW(),B10)), which puts the time of data entry
in B10 when C10 is filled. This works for the individual entry on the
PC of the user who made it, but, if another user saves, he gets the
time HE saved in C10 and (I'm assuming) that the last user of the day
to save would get the time HE saved on all other user's entries.

Any ideas?

 

[Spiky]

5 of us are using a shared workbook. We all enter data in columns in
the next empty row, eg one entry consists of typing data into C10,
D10, E10, F10, G10 & H10. If user 1 & 2 both happen to be typing in
stuff on (say) row 10 and user 1 saves and then user 2 saves, user 2's
data overwites user 1's and user 1's data is lost.

Also I'm using a circular reference,
IF(C10="",""IF(B10="",NOW(),B10)), which puts the time of data entry
in B10 when C10 is filled. This works for the individual entry on the
PC of the user who made it, but, if another user saves, he gets the
time HE saved in C10 and (I'm assuming) that the last user of the day
to save would get the time HE saved on all other user's entries.

Any ideas?

There is a setting in the sharing setup to force the 2nd user to
choose whether to overwrite recently saved data. I think that's the
best you can do, Excel's sharing is pretty limited.

You could also turn off simultaneous entry, but I'm not exactly sure
how that's different than simply not sharing the file in the first
place.

 

[robzrob]

There is a setting in the sharing setup to force the 2nd user to
choose whether to overwrite recently saved data. I think that's the
best you can do, Excel's sharing is pretty limited.

You could also turn off simultaneous entry, but I'm not exactly sure
how that's different than simply not sharing the file in the first
place.

Thanks. Would a template + database be better, do you think? That
forcing thing - do you mean the 'Ask me which changes win' thing?

 

[Spiky]

Thanks. Would a template + database be better, do you think? That
forcing thing - do you mean the 'Ask me which changes win' thing?

Yes, "Ask me which changes win". Its functionality is based on
everyone's use of it, though. So I can't say it will necessarily solve
your problem, that would be up to your users.

Maybe just have a separate data-entry worksheet for each person in the
shared workbook. A summary sheet can then use a macro to consolidate
them into one list whenever you need it.