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.

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" <(E-Mail Removed)> wrote in message
news:1987F048-C69A-4D5D-9816-(E-Mail Removed)...
> 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.