Associated Spreadsheets

  • Thread starter Thread starter Yuanhang
  • Start date Start date
Y

Yuanhang

I referenced a spreadsheet with a master spreadsheet, that is, all the cells
are well linked. However, sometimes, I wanna delete some rows or columns from
the master spreadsheet. As a result, the corresponding cells in the other
spreadsheet show #REF! up rather than being deleted as I expected.
 
And what you have posted is one of the reasons why I never link spreadsheets.
Deleteing cells in one workbook does not delete the refence in the other
workbook(s). If you intend to change one book you need fix the other book(s)
also. There is no easy way around it and there is no way to know what other
books might be linked back to the master.
 

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

Worksheet Formula Links 1
Lookups - how to obtain data from a master spreadsheet into another 5
Referencing Worksheets in separate Workbooks 5
Locating Source Data in Master Spreadsheet 3
Changing linked worksheet and range of cells 7
check box column 4
returning format from another spreadsheet 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top