links problem

  • Thread starter Thread starter PBcorn
  • Start date Start date
P

PBcorn

how can i make a link to cells in another workbook so that if the source
cells are cut and pasted, the link will still refer to the same cells, eg if
cut and paste down one, a1 does not become a2.
 
if you have link source not-so-many-cells, i prefer to "name" the source cell.
and the link formula on another sht. shall contain such name.
 
un fortunately i have alot of cells\links to apply this fix to. probably 400+.

do i have to name each one individually?

thanks
 
it's unfortunate to cut and paste the source cells if you have link separate
workbooks.
One way to do this is to ensure that all cross-linked workbooks are open
while performing such cut and paste action on source.
it is inconvenient to name each individual source cell >400.
 
You must log in or register to reply here.

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

workbook links 1
How to create absolue path link to another workbook (Excel 2003) 1
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Links error when insert line/row to source workbook 1
Fixed Reference 2
Target cell reference moves when target is cut and pasted 5
Referencing a cell even if its contents are moved moved/replaced 6
Excel Linking (I think) 17

Back
Top