Is there any way to take 2 similar files and find what changes you have added
to one and combine it with the original?

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?

Henry


"denny" wrote in message
...
Is there any way to take 2 similar files and find what changes you have
added
to one and combine it with the original?

"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

"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

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

denny,

What version of XL are you running?
Am I right in assuming that the file is shared?
If so, is the file on a server or is it on one of the 3 machines?

I've got an XL 2K workbook at work, shared with 4 other people.
The file sits on the office's server and we sometimes have problems with it.
These usually occur when more than one of us is trying to save at the same
time.
We get locked out and are sometimes unable to save the changes.
We don't seem to loose data in any other circumstances.
We do regular saves, about every 30 minutes.
After we've saved we see other peoples changes highlighted.
If there's an error in their input we can correct it then and there.
We sometimes get the "conflicting changes" message, asking who's changes to
accept, but this has never caused us any real problems.

Look in ToolsShare WorkbookAdvanced for some settings that may help.

Henry



"denny" wrote in message
...
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

"Henry" wrote:

denny,

What version of XL are you running? Win 98--Excel 2000
Am I right in assuming that the file is shared? Yes
If so, is the file on a server or is it on one of the 3 machines? It is on
the boss' machine, and 2 clerks up front add to it.

I've got an XL 2K workbook at work, shared with 4 other people.
The file sits on the office's server and we sometimes have problems with it.
These usually occur when more than one of us is trying to save at the same
time.
Yes, that is the problem. If we save every time we do a transaction, it
helps, but there is always still the chance of doing it at the same
time...and if we get occupied adding a bunch of data forget to do it each
line of new data.

We get locked out and are sometimes unable to save the changes.
We don't seem to loose data in any other circumstances.
We do regular saves, about every 30 minutes.
After we've saved we see other peoples changes highlighted.
If there's an error in their input we can correct it then and there.
Correcting it then and there may be important...I've found the highlight
part, and it may be helpful, but still required a lot of thinking to know how
it compares and what to save...but I think I've discovered it could help. It
also helps to save a backup of mine so that if the boss messes me up, I can
go copy from mine...IF I remember to do all that extra saving

We sometimes get the "conflicting changes" message, asking who's changes to
accept, but this has never caused us any real problems.

Look in ToolsShare WorkbookAdvanced for some settings that may help.

Henry



"denny" wrote in message
...
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