| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Absolute address in Workbook linking
Is it normal that when I link cells from worksheets in different Workbooks
the formula is always an absolute address? |
|
#2
|
|||
|
|||
|
Yes, that's the default behavior of Excel. Just get into the habit of
hitting F4 one, two, or three times prior to hitting enter, to change the reference type. HTH, Bernie MS Excel MVP "rfhorn" wrote in message ... Is it normal that when I link cells from worksheets in different Workbooks the formula is always an absolute address? |
|
#3
|
|||
|
|||
|
Thank you for the response.
"Bernie Deitrick" wrote: Yes, that's the default behavior of Excel. Just get into the habit of hitting F4 one, two, or three times prior to hitting enter, to change the reference type. HTH, Bernie MS Excel MVP "rfhorn" wrote in message ... Is it normal that when I link cells from worksheets in different Workbooks the formula is always an absolute address? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking workbook data | Excel Worksheet Functions | |||
| Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) | |||
| Linking Workbooks | Excel Worksheet Functions | |||
| linking cell value in one workbook to a cell in another workbook | Links and Linking in Excel | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
Linear Mode
