View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
Marnie
 
Posts: n/a
Default 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.