| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Absolute value changing in linked workbooks
I want to link Row 3 in workbookA to Row 5 in workbookB. In WorkbookB cell
A5 I have: =+[WorkbookA.xls]Sheet1!$A$3 The links are working except when I insert a row above Row 3 in WorkbookA. It changes the absolute reference to $A$4. I want it to remain linked to row 3. I would appreciate a suggestion. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When linked objects update in Word,it keeps changing the spacing? | Excel Discussion (Misc queries) | |||
| Changing source on multiple workbooks | Links and Linking in Excel | |||
| linked cells to workbooks in different folders | Excel Discussion (Misc queries) | |||
| LINKED WORKBOOKS - TOTAL CONFUSION | Excel Worksheet Functions | |||
| how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) | |||
Threaded Mode
