Links do move when a row is added

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet where multiple rows may be added during the month, but
the linked spreasheet does not recognize this change.
I was wondering if there is a way to either:
1. have the links update automatically
2 or have the linked spreadsheet open automatically when the first
spreadsheet is opened.
 
Hi Dana,

If your links are to cells that have new data added ahead of them (eg a
'Totals' row), then naming those cells and linking to the named ranges will
resolve the issue.

Cheers
 
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

Linking 2 spreadsheet using data from the last row of spreadsheet 13
can a linked spreadsheets sort automatically when data is added 2
Links error when insert line/row to source workbook 1
Linking 2 spreadsheet using data from 1st spreadsheet 1
Links pull wrong line when rows are added 1
copy 1 document and when original updated copy is also 4
Significant DELAY to open spreadsheets containing regular links? 6
Link a textbox on a sheet to a cell?! 2

Back
Top