Importing Microsoft query data into excel changes linked rows
 

I have a data-range that I import into excel from SQL tables. The problem is
that each time new records are added to the data and imported into excel, the
links I set to grab the data change and I dont want them to. Basically I
have a large row of data. Say from 1 - 100 and it is linked to another
datarange from 1 -100, but when the data-range updates, the sequential order
of the links is destroyed and skips several rows in the data source.

Thanks,

Raz

Importing Microsoft query data into excel changes linked rows
 

Maybe you should add a better index field to the table, then you could
modify your query to include only those records in a particular index
range.

Travis