Excel external data connection not working properly

Hello,

I made a connection between two workbooks where there is a master workbook and non-master workbook that uses the master as an external source and grabs a few columns from the master, but for some reason there are two columns that are not being copied over correctly. The columns show up in the non-master workbook, but the data entered in them are not showing up. The data only pops up if the second row of the columns have data entered into it. The two columns have drop-down lists, but so do other columns that are copying over with no problem. Does anyone know why that is happening? Any help would be greatly appreciated.

Thank you,

kvil