Working Together
Say two
people need to work on the same file at the same time. How would you
compare the two files and merge the changes? Microsoft Excel 2010
has a tool you can add that automates the steps:
Compare and Merge Workbooks.
1. Here
are some thoughts to consider:
Where
are you sharing your work?
For the
best results, you need to save all of the shared copies in the same
folder on the server.
Where
is the command button?
You also
need to customize the Quick Access and add the Compare and
Merge Workbooks
button. This option is NOT available in the Review
Ribbon by default.
Working
With the Same Shared Copies
Compare
and Merge Workbooks only works with copies of the same
Shared workbook. It cannot be used to combine
workbooks that are not Shared.
Keep
going...