View Single Post
  #1   Report Post  
Robert
 
Posts: n/a
Default Worksheet freezes on Data>Subtotal

I have a workbook of 10Mb. When attempting to Subtotal a relatively
small range (only 60r x 19c) a grey patch appears in the centre of the
worksheet and the worksheet freezes. What could be the problem and
the solution(s).The subtotals are for 4 cols.(The DataSort however
works fine). Using XP Professional 2002 on Intel 4 1.8Gh, 256Mb
(problem also apparent on another machine 2.4Gh 512Mb).

At wit's end. Thank you