referencing cells in another spreadsheet - do not update

  • Thread starter Thread starter dm
  • Start date Start date
D

dm

Hi

I'm currently referencing cells in another spreadsheet - lets say
spreadsheet B in another spreadsheet - lets say spreadsheet A.
Spreadsheet A has the links to spreadsheet B.

My problem is that if rows get inserted into spreadsheet B, and I open
Spreadsheet A and accept the update links option, my references are
all messed up. Is there any way for the references to follow the data?
I know this works if one is dealing with 2 sheets within the same
spreadsheet - so why not with 2 work books?

Any help would be appreciated

thanks
 
The term "spreadsheets" can be misunderstood.
It is better to use "Workbooks" (or "files") and "WorkSheets".

Have both workbooks open when making changes - otherwise how is Excel
to 'know' ?
 
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

Lookups - how to obtain data from a master spreadsheet into another 5
Significant DELAY to open spreadsheets containing regular links? 6
Cell shows the last typed text, no matter where it is typed 0
Can a spreadsheet recognize the current directory it is in? 2
Fixed/Locked cell referencing 6
Match 2 fields in 2 seperate Spreadsheets and fill another column 1
Multiple entries query 6
Associated Spreadsheets 1

Back
Top