HOLY CRAP....

This had nothing to do with xlt versus xls. The series range can not be obtained programatically unless the series has at least one data point. The solution was to put a data point (0) into every column of my template's data sheet, extract the range and then delete the data.