Stop linked cells from changing when insert new row?

[gorvic]

difficult to explain but here goes. I have a master workbook and have linked
(copy>paste special>paste link) cells from it to create several worksheets -
these worksheets have completely different formatting than the master.

My problem is that when i need to insert or delete a row from the master the
linked worksheets get jumbled - is there a way i can insert a new row into
the master without changing the locations of the linked cells in the other
worksheets?

Not really sure if it can be done but thoght i'd try.

 

[מיכ×ל (מיקי) ×בידן]

In the Master WS, try to declare NAMES to ranges/cells who are linked.
Micky


והמשך/×™, × ×, ×œ×§×¨×•× ×ת השורה הב××”:
***********
×× ×ª×’×•×‘×ª×™ עזרה לחץ/×™, × ×, על <כן> בפס ×”×ופקי התחתון!
***********
מיכ×ל ×בידן
מנהל ×¤×•×¨×•× "×ופיס" ב"תפוז"
[Microsoft" Most Valuable Professional [MVP"