Exam 77-428 Microsoft Excel 2013 EXPERT 1. Manage and Share Workbooks 1.1   Manage Multiple Workbooks: Merge Multiple Workbooks

Updating the Shared File 4. What happens when you click on Compare and Merge Workbooks? User1 and User2 both made changes to the same workbook. Say User1 went to the Quick Access toolbar and clicked Compare and Merge Workbooks.   Microsoft Excel will update User1's copy of the spreadsheet with User2's changes. A small window will pop up confirming that your workbook has been updated.   That was it: Excel compared both versions of the Shared workbook and updated User1's copy.   That's that...Let's take up a new topic. Quick Access Toolbar ->Compare and Merge Workbooks