Checkbox bug in Excel 2010; slow response

[Kakkmaddafakka]

Hi,

I have an excel spreadsheet containing about 1600 Developer Form control checkboxes (no macros) running in Excel 2010. They seem to make every action, such as zoom, merge, wrap, bold etc., in the sheet take about 5-6 seconds longer than the usual split second an action in excel should take. The file is 1.5 mb. The file has no links to other files, only internally, and does not contain macros or add ins.

The checkboxes are only for visual purposes: To use mouse to tick of a “v” or leave as blank, letting someone know that a job needs to be done/not done.


I have tried this with no change in the slow response:

• Delete all but 5-10 checkboxes
• Tried in 2010, on many different computers with different OS:
• Saved it as xls, xlsx etc.
• Changed the checkbox’s “Object positioning”
• Many hours in google; no help found

I have tried this with good results; no slow response:

• Tried in 2007 on different computers with different OS
• Delete ALL checkboxes

Possible reasons/solutions?:

• All the checkboxes are a result of copying a bunch of about 10 boxes, apprx. 160 times?
  • It is out of the question to try and make many unique boxes; need to make (too) many boxes to see effect in slow response.
• Bug in Excel 2010? If so, know how to fix?
• Try to make 1600 ActiveX control boxes instead of Form control?
• Delete all boxes, find alternative to the developer boxes; final solution if not possible to fix problem in 2010

Summary; How to remove slow response due to checkboxes in 2010. Help/guidance would be highly appreciated!

Thanks!
​

<!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

 

[wigi]

Cross-post:

http://www.ozgrid.com/forum/showthread.php?t=156666

 

[energman58]

I dont think it is really a bug as such - it is just the way 2010 is. The change from 2003 to 2007 messed up a lot of things for 2007 (many of which affected the screen drawing) and slowed it down a lot, 2010 fixed some of that in the traditional MS way - release something that doesnt work, fix it but release it as a new product so we can charge for it again - but it sounds like this was a bit of colateral damage.

Have you tried posting it on the MS help site (Windows Live) if you put bug in the header it usually gets the attention of someone competent

Keeping track of 1600 checkboxes will have a significant resource overhead even if you are not using them for anything. Could you use one of the Worksheet events (like SelectionChange?) to do the same job - maybe by changing the fill of the selected cell which would be very fast.