If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Absolute reference when linking workbooks
I notice when a link is created between 2 workbooks, Excel assumes an
absolute reference. Is there a way to set a default to assume a relative reference when linking workbooks? Thanks! |
#2
|
|||
|
|||
Absolute reference when linking workbooks
If you click on the formula in the formula bar and position the cursor
in a cell reference, you can then press F4 repeatedly to cycle between absolute and relative addresses. If you want to get rid of all the $ symbols completely, then highlight the cells, do CTRL-H and use Find/Replace to find $ and replace with nothing. Hope this helps. Pete On Mar 29, 10:26*pm, suejay wrote: I notice when a link is created between 2 workbooks, Excel assumes an absolute reference. *Is there a way to set a default to assume a relative reference when linking workbooks? Thanks! |
#3
|
|||
|
|||
Absolute reference when linking workbooks
When you create a forward link (source to target), XL makes it absolute.
When you create a backward link (target to source), XL makes it relative. Forward: Right click in source cell and choose "Copy". Navigate to, and right click in target cell. Choose "Paste Special", and click on "Paste Link", then Esc. Backward: Click in target cell and key in = sign. Navigate to, and click in source cell. Hit Enter. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "suejay" wrote in message ... I notice when a link is created between 2 workbooks, Excel assumes an absolute reference. Is there a way to set a default to assume a relative reference when linking workbooks? Thanks! |
Thread Tools | |
Display Modes | |
|
|