Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data to Excel using MS Query | Excel Discussion (Misc queries) | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) | |||
Is there an easy way to filter duplicate rows of data in excel? | Excel Discussion (Misc queries) | |||
Microsoft Excel in Microsoft works - how to open | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |