D
denny
Is there any way to take 2 similar files and find what changes you have added
to one and combine it with the original?
to one and combine it with the original?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Henry
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
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
D
denny
Henry said: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
H
Henry
denny said: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
D
denny
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.
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.
H
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 Tools>Share Workbook>Advanced for some settings that may help.
Henry
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 Tools>Share Workbook>Advanced for some settings that may help.
Henry
D
denny
Henry said: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.
Yes, that is the problem. If we save every time we do a transaction, itI'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.
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.
Correcting it then and there may be important...I've found the highlightWe 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.
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