| 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 |
| 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) | |||
Threaded Mode
