How to Merge Workbooks in Excel

Preparing a Workbook to Be Shared
1. Open the workbook you want to distribute.
2. Open the Tools menu and click Share Workbook, and then click the Editing tab.
3. Select the 'Allow changes by more than one user at the same time' box.
4. Click the Advanced tab.
5. Under 'Track changes,' click 'Keep change history for.'
6. In the Days box, type a few days longer than the number of days reviewers will spend making changes and comments in the shared workbook.
7. Click OK.
8. Save the workbook.
9. Make copies of the workbook to distribute by using the Save As command in the File menu. Give each copy a different name, such as 'Budget - Sulhi copy' and 'Budget - Marina copy.'
Merging the Shared Workbooks Back Together
10. Open your base copy of the workbook you distributed.
11. Open the Tools menu and select Merge Workbooks.
12. Save the shared workbook if you are prompted.
13. In the box that appears, select one of the copies you made of the workbook.
14. Click OK.
15. Repeats steps 2 through 4 until all copies of the shared workbooks are merged.