I've been comparing and merging workbooks for a long time now. I just came across a problem I'm unable to resolve.

One of the workbook I'm merging to the parent workbook is not transferring the new data. It is going thru the merging process and no errors so the relationship is still intact. The other workbooks I used are able to merge and transfer new data.

Thanks.