I have a question about Excel. I have a large Master spreadsheet (chart) with a list of data which is the first tab in Excel.

I used the paste special link feature to break up or separate the information, and when I make a change to the data (i.e. name change) in the master spreadsheet, the other tab(s) change automatically which is great.

However, if I try to delete a row (data I no longer need) or add a new row of data to the master spreadsheet, the corresponding tabs do not automatically update to reflect the master spreadsheet’s added or deleted information. Would you happen to know what I can do to fix this to avoid having to go into each tab and make the change?