Merge copies of a shared workbook

In the Excel Web App, available in Windows Live or with Microsoft SharePoint 2010 technology, multiple users can edit data in a worksheet in the browser at the same time.
Read a blog post or try Office 365!

When a shared workbook is updated by other users, and you want to compare the changes that they have made before you update the workbook with those changes, you can use the Compare and Merge Workbooks command. This command is not available with other shared workbook commands on the Review tab in the Changes group, but you can add it to the Quick Access Toolbar.

Note   You can only merge a shared workbook with copies of that workbook that were made from the same shared workbook. You cannot use the Compare and Merge Workbooks command to merge workbooks that are not shared.

Important   To use the Compare and Merge Workbooks command, all shared workbook users must save a copy of the shared workbook that contains their changes and use a unique file name that differs from the original workbook. All copies of a shared workbook should be located in the same folder as the shared workbook.

  1. If needed, do the following to add the Compare and Merge Workbooks command to the Quick Access Toolbar:

    1. Click the Microsoft Office Button Office button image, and then click Excel Options.

    2. In the Customize category, in the Choose commands from list, click All Commands.

    3. In the list, click Compare and Merge Workbooks, click Add, and then click OK.

  2. Open the copy of the shared workbook into which you want to merge the changes.

  3. On the Quick Access Toolbar, click Compare and Merge Workbooks.

    Quick Access Toolbar with Compare and Merge Workbooks button

  4. If prompted, save the workbook.

  5. 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.

    Tip   To merge the workbook with multiple copies of the shared workbook at the same time, hold down CTRL or SHIFT and click their file names, and then click OK.

Applies To: Excel 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language