I have found a few posts asking this question but no responses which
solve the problem.

An example is here:
http://groups.google.co.uk/group/mic...c3d5a9fe7a900e

I am using a Query to a SQL Server database to import data into excel
and I am having problems when the data refreshes.

I notice that when a row is removed or added (in the database affecting
the query) my row data becomes skewed.

For example consider the following:

row 1 data 1
row 2 data 2
row 3 data 3


When a new row is inserted via the data refresh:

becomes:
row 1 data 1
row 2 data 2
new 1 data 3
row 3

when is should become:

row 1 data 1
row 2 data 2
new 1
row 3 data 3

When a row is deleted via the data refresh

becomes:
row 1 data 1
row 3 data 2
data 3

when it should become:

row 1 data 1
row 3 data 3

I have tried changing the Data range properties but I am unable to
solve the problem.

Any help would be greatly appreciated