I'm having the same problem. I checked the formatting of the cells and
character length and everytrhing lines up. The table I'm pulling the data
from is a pivot table. Is this the root of my problem?