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.