importing data into sheet with subtotals
 

Can data be refreshed into a spreadsheet that has been subtotalled? when I
do the refresh, the data is dropped in, the formatting goes out the window,
and the results is a mess.

How do I refresh data into a spreadsheet, maintain its format and get the
current, accurate results?

thank you.