Compare and Merge

The Quick Access Toolbar should have a new button, Compare and Merge Workbooks. In the image on this page the custom button is to the right of the Undo and Redo arrows.

 

 

3. What if two people edit the same file?

Say there are two people who go to the same folder and open the same Shared workbook.

 

Say User2 clicked on Find and Replace to get all of the Pita Platter sales and format the data orange. User2 then SAVED her changes.

 

Keep going...

 

Memo to Self: Some of these examples cannot really be tested if you are working alone.

Exam 77-888: Microsoft Excel Expert 2010

1. Sharing and Maintaining Workbooks

1.3. Maintain shared workbooks

Quick Access Toolbar ->Compare and Merge Workbooks