I don't think so, usually when I don't want it I select the other workbook,
then select the cell(s), then I press F4 three times
that will make it relative without too much editing

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)


"Rebecca" wrote in message
...
Is there a way to change Absolute Reference so that it is NOT the default
for
linking to another workbook? Most of the time I want to link rows or
columns
of data from another workbook (as part of a calculation). I would like to
enter the calculation by linking to the first cell and dragging the
formula;
but I must remember to take out the Absolute Reference each time. I do
this
a lot.
--
Rebecca