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

Exam 77-888: Microsoft Excel Expert 2010

1. Sharing and Maintaining Workbooks

1.3. Maintain shared workbooks