All copies of a shared workbook should be located in the same folder as the shared workbook. Click the Microsoft Office Button , and then click Excel Options. In the Customize category, in the Choose commands from list, click All Commands. In the list, click Compare and Merge Workbooks, click Add, and then click OK. Open the copy of the shared workbook into which you want to merge the changes. On the Quick Access Toolbar, click Compare and Merge Workbooks. If prompted, save the workbook. In the Select Files to Merge into Current Workbook dialog box, click a copy of the workbook that contains the changes that you want to merge, and then click OK.