Compare and Merge Workbooks

Question: How can you compare and merge copies of a shared workbook?

Answer: By using the Compare and Merge Workbooks command. (This command will have to be added to the quick access toolbar, since it is not available on the Review tab)

Why: When you want to verify the updates made by other users and need to compile the final version of the document.

All users of the shared workbook 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.

Applies To: Excel 2003, 2007 and 2010

Steps for adding the Compare and Merge Workbooks command to the Quick Access Toolbar:

Click the File tab, and then select Options
Select as below:

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

2. On the Quick Access toolbar, select as below;

3. If prompted, save the workbook

4. In the Select Files to Merge into Current Workbook dialog box, select a copy/copies of the workbook that contains the changes that you want to merge, and then click OK

If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email enablement@alchemex.com and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations

Digg Digg