View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BrianH
 
Posts: n/a
Default Group & Outline and Recalculation

I recently upgraded from Excel 2000 to 2003
I use Group & Outline in large spreadsheets to facilitate navigation and
reduce clutter on the screen.
In 2000 this worked well, virtually instantaneously. In 2003 it seems to
generate a recalculation each time an outline is expanded or contracted - the
status bar shows "Calculating cells: 100%". The recalc time seems to be
related to the number of rows / columns affected, and / or the complexity of
the outline nesting, and by expansion more than contraction.
The larger the workbook and the longer the model's recalc time, the more
important the facility is to me, but the more tedious it becomes waiting for
it to happen, to the point that it's becoming more trouble than it's worth.

Does anybody know how to prevent the recalc? It doesn't respond to Escape
or any other keybard input - you just have to wait for it to do whatever it
is it's decided to do!