Importing Microsoft query data into excel changes linked rows Wazzy_bear 15.12.2005 00:25:31 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

Re: Importing Microsoft query data into excel changes linked rows "travis" <travismorien[ at ]yahoo.com> 19.12.2005 09:09:25 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