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
Bookmarks