Update link to another workbook w/o absolute ref

A

Andy at BLE

I've linked
Workbook A, Sheet 1, A2
with
Workbook B, Sheet 1, C3.
The link formula resides in Workbook A.

The link treats the cell reference as absolute, so if I
resort rows, for example, in Workbook B so that the C3
moves to D4, the link still refers to C3.

Does anyone know how to write a link so that it will not
be absolute? Is that possible?

Thanks. Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create absolute link to cell in another workbook (Excel 2003) 1
XL2000 Links Between Workbooks 2
How to create absolue path link to another workbook (Excel 2003) 1
trouble with (complicated) vlookup searching another workbook 2
Absolute Reference Changes 2
Retaining cell reference in destination, when sorting source file 3
Losing rows that reference data from another worsheet 1
Hyperlink to another worksheet to a absolute cell 1

Top