Connection to Another Excel Document???

Hi All,

I am trying to connect two excel documents together, the first is a document another department updates daily. I am using a connection to this document. The connection works perfectly until I get to the portion where the items numbers go from being all numbers to a mix of numbers and letters. At this point the "item number" stops displaying (The first column) while all other columns populate the correct data. The only portion of the first document that does not display in my second document through my connection are these "item numbers" that are a mix of numbers and letters. I have no idea why this is happening. Any Ideas?

Thanks For Your Help