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 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. |
#2
|
|||
|
|||
Absolute value changing in linked workbooks
One way:
=INDEX([WorkbookA.xls]Sheet1!$A:$A,3) Note that your leading + is superfluous in XL. In article , Marnie wrote: 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. |
#3
|
|||
|
|||
Absolute value changing in linked workbooks
That worked! Thank you!
"JE McGimpsey" wrote: One way: =INDEX([WorkbookA.xls]Sheet1!$A:$A,3) Note that your leading + is superfluous in XL. In article , Marnie wrote: 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. |
#4
|
|||
|
|||
Absolute value changing in linked workbooks
The other thing to do is to ensure WorkbookB is open when you are
modifying WorkbookA Or if you name the cell in WorkbookA, for example "MyCell" then you can insert and delete ranges that move MyCell and a link: =[WorkbookA.xls]Sheet1!MyCell will still work Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linked workbook(s) | Tom | General Discussion | 1 | April 3rd, 2006 09:39 PM |
Finding linked cells to other workbooks | [email protected] | General Discussion | 1 | October 20th, 2005 03:31 PM |
Linked cells in Multiple Workbooks | Ediehl55 | General Discussion | 1 | November 18th, 2004 12:57 AM |
changing many cells reference to absolute | Woody13 | General Discussion | 3 | November 1st, 2004 10:35 PM |
linked workbooks | dmk | Worksheet Functions | 1 | August 9th, 2004 07:54 PM |