I need a better answer if anyone has one. 3 of us, using different computers
all need to add to the same file and sometimes it seems to knock out
important information when it asks if we want to save the other person's
changes. Then we need to be able to see what the other person added and what
got knocked out.

"Henry" wrote:


"denny" wrote in message
...


"Henry" wrote:

denny,

Just saving the new file using the old file's name will do that.
Or are you talking about file sharing, where more than one person can
work
on the workbook at the same time?

I thought that over wrote the old file. My concern is if you have made
some
accidental changes, and you want to be able to preserve the good facts
without losing all the old. Yes, in a sharing situation, others have
knocked
out my good facts and I had to spend quite awhile comparing line by line,
window by window

That would be very difficult, as a row added or deleted would mean that
anything below that line will be a change (of row number).
How about password protecting the workbook and allowing read-only access to
other users.
That way, only you will be able to change the data but others will be able
to look at it.


Henry