Program error when using Compare and Merge Workbooks

[Gan]

Dear all,

I sent out an excel file to other colleagues of my in different countries to
update some figure. after getting the revised version, i try to used the
Compare and Merge Workbooks function in Excel to consolidate the data. But
while doin it on some file, I been kick out from Excel and "Send Error
Report" dialog box been prompt.

Had anyone have any idea to solve this error. Thank.

Regards,
Gan