On a weekly basis the company at which I am on assignment downloads data
from a huge database which they then cut and paste into various Excel
reports. I want to replace this cut and paste process using external links
from the reports to the downloaded data files (which are created by .csv to
.xls). Once this is set up, theoretically, I will be able to download a new
set of data files and then when I open the Excel reports the cells in the
reports will update automatically with no cutting and pasting between files.

The only rub is that sometimes a row or column might be added within the
source data, which would throw off the links in the Excel reports. To
minimize this damage, I would like the links to be relatively addressed, so
I could insert a row/column in an Excel report to reflect an added
row/column in the source data without messing up all the rows/columns which
follow. However, after copying a column of data and using Paste
Special/Paste Link into my Excel report, I see that the links created in my
Excel reports are not relative (no dollar signs).

Is there some way I can make this happen, or do you have another/better way
to do this? Let me know if I'm not explaining this well.

Thanks in advance,
David Portwood