Import External Data to template format 2007
 

In Excel 2003, I could import data from one Excel worksheet into another
(with format from template), and the data would inherit the formatting of the
template and display accordingly. I can't for the life of me figure out how
to do this in Excel 2007. In 2003, one could set the External Data Range
Properties prior to importing data -- in 2007 this doesn't seem to be the
case. I am able to import the necessary data, but the format is all wrong.