Merging identical workbooks in Excel 2007
 

I have created a workbook with several interlinked sheets that I want to
provide to 2 different people in different locations. Periodically, I want to
consolidate the 2 versions into an updated one. One person is not online, so
I need to regularly get copies of each and merge. I have followed online
instructions and added 'Compare & Merge Workbooks' command to the Quick
Access Toolbar. However, when I click on it nothing happens! Any advice?