View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Blackwell John Blackwell is offline
external usenet poster
 
Posts: 9
Default Sorting linked worksheets

I'm using a massive workbook with multiple linked worksheets. Unfortunately,
when I sort one of the 'master' worksheets, my links are scrambled because
they follow the cell rather than the data.

To illuminate the issue, I have separate 'master' worksheets for
"capabilities" and for "enablers" - these are linked in subsequent worksheets
using the ='Enabler Definitions'!Bxx function.

Is there a simple way of curing this problem?