Absolute Reference

[Guest]

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.

 

[Peo Sjoblom]

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)

 

[Guest]

Rebecca,

You can perform the operation by marking, then copying the range in the
original workbook. After that, select the cell in the new work book where
you want to begin pasting. Click on the edit menu, select paste special. On
the bottom left side of the dialog box, click on the paste link button. Your
range should be pasted into your new workbook sans the absolute addressing.

Hope this helps you...

p.s. It is possible to use this method for an entire row or column. Be
aware, however, that your spreadsheets will get very large if you do this
with more than a few rows/columns.

 

[Peo Sjoblom]

It will still return absolute references when linking to another workbook

--


Regards,

Peo Sjoblom

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

 

[Guest]

I checked the functionality again and found a wrinkle...

If you copy and paste a single cell only, absolute addressing is used. If
you copy and paste a range of multiple cells, at least on my copy, indexed
addressing is used.