This is something I have never done, but an curious on how it would work.  I
have been looking around here and on Google, but haven't quite found what  I
am looking for.  To be upfront my preference would be to just keep this
entire system I am going to discuss in Access, but NO ...

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 ...

Hi all, I have discovered a difference of behaviour which I would be
interested in hearing others' views on...
we have a master spreadsheet which contains links to other workbooks,
some in the same location (or subfolders of) x: and some in a different

I've just switched from one Access application to another as the data
source for an Excel spreadsheet, as a result I'm having to swt up all
the links all over.
Inserting the new links isn't a problem, but I can't seem to get rid of

I am using Excel 2002.  I have 9 workbooks which have extensive linking.  
Eight of the workbooks auto update the links when they are opened by
themselves.  One workbook, however, gives me the warning that some links
cannot be updated when it is opened by itself.  Also, I do not ...

Can anyone help me with this?  I have looked all through Excel help and the
only hyperlink info concerns inserting them into a cell.
I have a spread sheet that has numerous named sheets within it.  Opening the
spreadsheet from a hyperlink on a webpage always opens it on sheet # 1.

It is a long time since I have used excel and need help I want to use an
invoice and the data to be inserted into a spreadsheet at the same time.
Must be my age cannot remember how it works.
Any help would be gratefully received.