Compare and merge in 2007
 

I have a shared workbook which was distributed to 3 different users to add
information into. Information from User 1 can be merged into the 'master'
spreadsheet successfully. Changes made by User 2 & 3 will not merge and no
errors are received.