You could record a macro to do the import followed by the parsing
(text-to-columns)
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Daniel" wrote in message
...
I have a chart based on imported data from a database. The problem is
after
anytime I refresh data, the chart is colasped, all data become straight
line
at 0. I have to click data/text to column/fixed width/finish to get my
chart
back.

My question: How can I format the worksheet so that I don't have to do
this
after refresh data?

Thanks
Daniel