New user to DTS using excel destination component. Excel spreadsheet has
pivot table dependent upon the data I am loading into a separate worksheet
from the excel destination component of DTS in the same spreadsheet. When I
do not format the columns of the pivot table everything works just fine.
When I format the columns of the pivot table all values referenced in the
data worksheet are pushed in as text from the DTS component, that is they are
preceded with an '. Very strange! Any suggestions?

Thanks,

trentg