Hi, Peter,

I found your post very interesting because I'm experiencing the
*opposite* problem.

I have been using Edit-Paste Special-Paste Link in a complicated
spreadsheet where I *want* relative references.

In the past I'm pretty sure that using this method I always got
relative references, but recently I get absolute references which I
then have to change with F4.

I've been googling for a way to set the default for this command to
relative. I can't figure out what setting might have been
inadvertently changed.

Hope we both get an answer soon. Using F4 for each individual cell on
a huge spreadsheet is a pain.

Lucian


--
LWD
------------------------------------------------------------------------
LWD's Profile: http://www.excelforum.com/member.php...o&userid=29990
View this thread: http://www.excelforum.com/showthread...hreadid=488097