View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sf sf is offline
external usenet poster
 
Posts: 12
Default Cells no longer linked after inserts

I linked several worksheets with a mastersheet and the info updates fine,
until I insert a new column. Some of the linked cell formula change to
incorporate the new postition on the mastersheet, but others don't. I end up
having to change the formula so they can match the new position. Is there
anyway I can stop this from happening so that when the originals move
position the linked cells continue to reflect the correct info.