i am linking two files. i would like to be able to link one cell and then
just drag that reference down so that it copies the formula - as is the case
in a regular spreadsheet. however, i notice that when you link workbooks,
you get an absolute cell reference so you can't just drag the formula and
fill in subsequent rows. i know that you can edit out the absolute
reference. however, is there a reason that it is a good idea to have the
absolute reference? don't want to do anything that may cause me problems
down the road. any thoughts on this?

thanks
--
aprilshowers