Important: This article explains an older method of merging copies of a "Shared Workbook" – an older feature that allows you to collaborate with multiple people. This feature has many limitations, and has been replaced by co-authoring. Co-authoring is much better at merging changes, and is available in certain versions of Excel, including Excel for Microsoft 365 subscribers.Buy or try Microsoft 365
Important: Be certain that you want to use this method before continuing. Shared Workbooks have limitations, and one in particular is the inability to edit using Excel for the web. Therefore we highly recommend co-authoring, which is the replacement for Shared Workbooks.
-
Click the Review tab, and see if the Share Workbook button is visible. If it isn't visible, you'll need to unhide it. You'll also need to unhide the Compare and Merge Workbooks button. This article explains how to unhide these buttons.
-
On the Review tab or on the Quick Access Toolbar, click Share Workbook
-
Click Allow changes by more than one user...
-
Now ask other people to open the file, and save a copy of it with a unique file name that differs from the original's name. Also tell them to put their copies in the same folder as the original workbook.
-
Tell them to make changes to their copy, and save.
Notes:
-
You can only merge a workbook with copies made from the original.
-
You can't merge a workbook that hasn't had the Allow changes by more than one user... setting turned on.
-
-
Open the original Shared Workbook into which you want to merge 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 the copy of the workbook that contains the changes you want to merge. To merge multiple copies at the same time, hold down Ctrl or Shift and click the file names, then click OK.
Important: Be certain that you want to use this method before continuing. Shared Workbooks have limitations, and therefore we highly recommend co-authoring instead.
-
On the Review tab, click Share Workbook.
-
On the Editing tab, click Allow changes by more than one user...
-
Now ask other people to open the file, and save a copy of it with a unique file name that differs from the original's name. Also tell them to put their copies in the same folder as the original workbook.
-
Tell them to make changes to their copy, and save.
Notes:
-
You can only merge a workbook with copies made from the original.
-
You can't merge a workbook that hasn't had the Allow changes by more than one user... setting turned on.
-
-
Open the original Shared Workbook into which you want to merge changes.
-
Click the Tools menu and then select Merge Workbooks….
-
If prompted, save the workbook.
In the file navigation dialog box, click the copy of the workbook that contains the changes you want to merge, then click OK.
