Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
absolute reference in linked files
i am linking two files. i would like to be able to link one cell and then
just drag that reference down so that it copies the formula - as is the case in a regular spreadsheet. however, i notice that when you link workbooks, you get an absolute cell reference so you can't just drag the formula and fill in subsequent rows. i know that you can edit out the absolute reference. however, is there a reason that it is a good idea to have the absolute reference? don't want to do anything that may cause me problems down the road. any thoughts on this? thanks -- aprilshowers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
absolute reference in linked files
however, is there a reason that it is a good idea to have the absolute
reference? It's not good or bad. It's solely a matter of what you want to happen to the references when you copy/paste the formula. -- Jim "april" wrote in message ... |i am linking two files. i would like to be able to link one cell and then | just drag that reference down so that it copies the formula - as is the case | in a regular spreadsheet. however, i notice that when you link workbooks, | you get an absolute cell reference so you can't just drag the formula and | fill in subsequent rows. i know that you can edit out the absolute | reference. however, is there a reason that it is a good idea to have the | absolute reference? don't want to do anything that may cause me problems | down the road. any thoughts on this? | | thanks | -- | aprilshowers |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
absolute reference in linked files
Abslolute referencing works the same whether or not the cell being referenced
in in the same workbook or not. You can press the F4 key to cycle through the various flavors of the relative/absolute/mixed references until you get to the reference you want. -- Kevin Backmann "april" wrote: i am linking two files. i would like to be able to link one cell and then just drag that reference down so that it copies the formula - as is the case in a regular spreadsheet. however, i notice that when you link workbooks, you get an absolute cell reference so you can't just drag the formula and fill in subsequent rows. i know that you can edit out the absolute reference. however, is there a reason that it is a good idea to have the absolute reference? don't want to do anything that may cause me problems down the road. any thoughts on this? thanks -- aprilshowers |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
absolute reference in linked files
thank you. i think that i'll take out the absolute reference - makes it
easier to copy without it. -- aprilshowers "Kevin B" wrote: Abslolute referencing works the same whether or not the cell being referenced in in the same workbook or not. You can press the F4 key to cycle through the various flavors of the relative/absolute/mixed references until you get to the reference you want. -- Kevin Backmann "april" wrote: i am linking two files. i would like to be able to link one cell and then just drag that reference down so that it copies the formula - as is the case in a regular spreadsheet. however, i notice that when you link workbooks, you get an absolute cell reference so you can't just drag the formula and fill in subsequent rows. i know that you can edit out the absolute reference. however, is there a reason that it is a good idea to have the absolute reference? don't want to do anything that may cause me problems down the road. any thoughts on this? thanks -- aprilshowers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked Files - How to find reference | Excel Discussion (Misc queries) | |||
Relative vs. Absolute Path Names for linked cell data | Excel Discussion (Misc queries) | |||
what is absolute reference | Excel Discussion (Misc queries) | |||
Absolute value changing in linked workbooks | Links and Linking in Excel | |||
absolute reference | Excel Discussion (Misc queries) |