Merging Two Workbooks

Requirements must be met:

• The two workbooks must be copies of the same file, which must be a shared workbook.
• The two workbooks must have different filenames.
• The two workbooks must either have the same passwords or not be password-protected.
• The Track Changes feature must be turned on for both workbooks from the time the copy is first made.
• The tracking history must be kept from the time the copy is first made.

• Open the workbook into which you want to merge the files
• Tools-> Compare and Merge Workbooks