B
BothXP
Hi,
Has anyone come across this setup before?
A user here has inherited an excel spreadsheet which is setup to be
shared. Users access the file and add information to the bottom of the
current list. Now if 2 users try to add new data to the same line when
the second user saves they don't see the conflict resolution box as I'd
expect but rather the new data is actually moved down a line and then
saved.
It almost looks as if the files are being merged but I've tested it out
and it does appear to be just saving a shared file.
I've had a good look at the file and can't see any settings for this
and there are no macros in the file (I removed the shared option to
check).
Now they want another excel file to have the same behaviour.
Any one got any ideas of what I might be missing here.
Thanks
Has anyone come across this setup before?
A user here has inherited an excel spreadsheet which is setup to be
shared. Users access the file and add information to the bottom of the
current list. Now if 2 users try to add new data to the same line when
the second user saves they don't see the conflict resolution box as I'd
expect but rather the new data is actually moved down a line and then
saved.
It almost looks as if the files are being merged but I've tested it out
and it does appear to be just saving a shared file.
I've had a good look at the file and can't see any settings for this
and there are no macros in the file (I removed the shared option to
check).
Now they want another excel file to have the same behaviour.
Any one got any ideas of what I might be missing here.
Thanks