link workbooks

  • Thread starter NewExcelUserwithManyQuestions
  • Start date
N

NewExcelUserwithManyQuestions

I'm having a problem with linking workbooks and keeping cells linked to their
correct cells when adding lines.

For example, in one workbook (linked) I have a cell linked to A4 in another
workbook (source). After I've created the link, I save and close both
workbooks. Let's say later I open the source workbook, add a line that
shifts all the data down a row, save and close. When I open the linked
workbook, my linked cell is still pulling from A4 instead of A5.

Is there a way to add lines in source workbooks and keep links in linked
workbooks without them both be open at the same time?
 

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

Top