Controls slow down worksheet response times
 

We are noticing that large numbers of controls, such as check boxes, on
Excel 2007 worksheet fill-in forms, tend to slow down the worksheet. The
initial load and later recalculations or refreshes are slow. This leads to
two questions:

FIRST, are the 'Form Controls' or 'ActiveX Controls' more efficient? Or,
perhaps, they are both equally efficient? The thought being that a more
efficient control might retard the display refresh less.

SECOND, is there a way to prevent the controls from recalculating everytime
there is a worksheet change? Other calculations are not slowing the
worksheet, just the 100 or so controls. If possible we would like to turn
the control updates OFF until we force a manual update. Is this possible?

Thank you for any help.

Controls slow down worksheet response times
 

I suspect there is not much difference between Form Controls and Active X
controls, but I have not tested it.

Two suggestions:
- Move all your controls off worksheets and onto a sequence of data entry
forms.
OR - move all your calculations off the sheet that contains the controls
and try switching off .EnableCalculation for the Controls sheet unless
active


Charles Williams
Decision Models

"Blue Max" wrote in message
...
We are noticing that large numbers of controls, such as check boxes, on
Excel 2007 worksheet fill-in forms, tend to slow down the worksheet. The
initial load and later recalculations or refreshes are slow. This leads
to two questions:

FIRST, are the 'Form Controls' or 'ActiveX Controls' more efficient? Or,
perhaps, they are both equally efficient? The thought being that a more
efficient control might retard the display refresh less.

SECOND, is there a way to prevent the controls from recalculating
everytime there is a worksheet change? Other calculations are not slowing
the worksheet, just the 100 or so controls. If possible we would like to
turn the control updates OFF until we force a manual update. Is this
possible?

Thank you for any help.