
They cannot have passwords applied to them. They must all have different files names, but must all be located in the same folder. First, all merged workbooks must be copies of the original shared workbook. There are a few requirements the files must meet before you can merge them together. In this case, you can take those workbook files and merge the changes together into a single workbook. You can merge changes in copies of shared workbooks in Excel if you have copies of a shared workbook into which different users have made changes.

This is an older method of reviewing changes to a shared workbook in Excel, but it still works. This lesson shows you how to merge changes in copies of shared workbooks in Excel.

Merge Changes in Copies of Shared Workbooks in Excel: Overview
