Compare And Merge Excel Files

[Negative Zero]

i've got a bit of a problem, and i'm hoping someone can shed light on it. i use excel to maintain my personal phone book. problem is, i keep two copies, (one at work and one at home). through negligence (and perhaps a little laziness ) i've neglected to keep them both up to date with each other.

 

i didn't think this would be a problem, and i knew you could do a compare and merge in Word, and i figured there had to be a similar feature in excel. except the command is greyed out, and i don't know why. on my home PC i've got all Office options installed, and the command is still greyed out. what gives?

 

how do i use the command? anyone? ... anyone at all?

 

~NegZ

Edited September 13, 2003 by Negative Zero

[surefire]

I don't have an answer that will help you merge the files... but once you get them straight, you can keep your two copies up to date by using My Briefcase in windows.

[TCH-Dick]

For each workbook, Go to Tools>Share Workbook.. On the Edit tab select a user or the check box that says:

 

"Allow changes by more than one user at a time.

This also allows workbook merging."

 

Select OK and the Compare and Merge option will then be selectable.

 

Thumbs Up

[Negative Zero]

very cool. many much thank yous, and all that i can now access the merge command, but sadly, it won't let me merge the two files, since they haven't had any change histories saved! oh well.

 

surefire

doesn't My Briefcase simply overwrite the older file with the newer one? there are independant changes to both files that i need to keep.

 

~NegZ