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?
o 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?
- 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

It would be highly appreciated if an answer to this problem can be provided! I am out of ideas!

Thanks!