Controls slow down worksheet response times

[Blue Max]

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.

 

[Charles Williams]

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