Absolute reference when creating links to another workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

I would like to know why Excel creates absolute references when we create a link to a cell in another worksheet using the mouse to select the cell (=[Workbook.xls]Sheet1!$A$1)??

When we link to a cell in the same workbook, Excel uses relative references (=Sheet1!A1)

Instead of using the mouse, if we use copy/paste special/paste link, Excel creates absolute references whatever where the source is (same or different workbook)

Is that making a difference? Can you explain please and let me know the best choice if I manually type the formulas?

Thank you so much :)
 
I know what's the difference between absolute and relative adressing within a spreadsheet (when copying cells it determines what should be adjusted and what should remain unchanged). What I don't understand is why we NEED to use absolute adressing when creating a link between 2 cells.
 
Hi
you don't have to. You can change this to a relative cell address
without a problem. Remove the '$' signs or hit F4 to toggle between the
reference types

--
Regards
Frank Kabel
Frankfurt, Germany

Hugie said:
I know what's the difference between absolute and relative adressing
Click to expand...
within a spreadsheet (when copying cells it determines what should be
adjusted and what should remain unchanged). What I don't understand is
why we NEED to use absolute adressing when creating a link between 2
cells.
 
Back
Top