Links

G

Guest

How do I make links move with a cell.
ie: I have data in one work book linked to another wokbook but whenever
lines are added to the source book and the cell containing the data I want
moves, the link in the destination workbook does not follow the cell.
Can this be fixed or should I be using something other than a link??
 
G

Guest

You need to have both files open at the same time when you are inserting
lines the other open the first one gets updated. After you are done adding
rows/column save both documents. Next time you open the file it is reflecting
the correct/updated changes.
 

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

Linked Workbooks/Sheets 1
How to create absolue path link to another workbook (Excel 2003) 1
Links error when insert line/row to source workbook 1
Link error #VALUE 5
fixed links to another workbook 4
Updating Links from Closed Source Workbooks 2
Workbook links 2
External Referance over Network 1

Top