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
has a tool you can add that automates the steps:
Compare and Merge Workbooks.
are some thoughts to consider:
are you sharing your work?
best results, you need to save all of the shared copies in the same
folder on the server.
is the command button?
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.
With the Same Shared Copies
and Merge Workbooks only works with copies of the same Shared workbook. It cannot be used to combine
workbooks that are not Shared.