External data refreshing to include new rows
 

Hello,

I am currently trying to find a solution to my problem. On my worksheet I
have a number of colums linked to external data and at the end of these,
columns that are not linked to external data.

When I come to refresh, I currently have the setting insert new row, which
it does but only for the external data columns. How do I get it to include
the non external columns when inserting new rows, so all previous
information stays on the right line.

I am using excel 2003