Excel got problems with many controls?

  • Thread starter Thread starter Tim Bücker
  • Start date Start date
T

Tim Bücker

Hello.

I have an excel file with 20 pages including textboxes, checkboxes and
buttons.
Each page contains around 100 of these controls; mostly textboxes.

Starting this excel file I got many display errors:
- some regions of the screen are not always updated correctly
- textboxes are not shown instead a right cross is displayed
- font style and size is changing sometimes

Has excel a problem with such a number of controls?
Does anybody know a possible workaround?

Any comments and help is welcome.
Thanks a lot in advance!

Greetings.
Tim.
 
I've read posts that say too many controls from the control toolbox toolbar
placed on a worksheet can cause problems with excel.

But I don't recall seeing a definitive number.

Are your controls from the control toolbox toolbar (or maybe from the
Forms/Drawing toolbars)?

I've also read posts that say that controls from the forms and drawing toolbars
behave better.

You may want to try them in a test workbook.

I've never used this, but lots of people say that OpenOffice can sometimes open
these kinds of workbooks. If you save it, maybe any possible corruption could
be deleted?????

(http://www.openoffice.org, a 60-65 meg download or a CD)
 
Dave Peterson said:
I've read posts that say too many controls from the control toolbox toolbar
placed on a worksheet can cause problems with excel.
But I don't recall seeing a definitive number.
Click to expand...

Hello. First of all thanks for the answer.
I am using the controls from the control toolbox toolbar but playing around
with different excel files
it seems that not the number of the controls is the real problem but in case
of the textboxes the text in them.

Having about 2000 empty textboxes is not a problem but having 2000 textboxes
with text in each of them causes
the memory chaos. I will now try to set the maximum length from 0 to 2.
Perhaps that will save some memory?!?
I've never used this, but lots of people say that OpenOffice can sometimes open
these kinds of workbooks. If you save it, maybe any possible corruption could
be deleted?????
Click to expand...

Unfortunately, OpenOffice is not saving the excel file without data loss.
But it seems to have a far better memory mangement - I´ve got no problems to
open and close the file here.
No display errors and everything is running very fast and smooth. Damn that
VBA-Code is not running in OpenOffice ;-)

Again, thanks a lot for answering.
Greetings,
Tim.
 
There's a textbox on the drawing toolbar. It's a lot less customizable and
behaves slightly differently.

Maybe a small (er, large experiment!) would help you decide if you could replace
the control toolbox textbox with the drawing toolbar textbox.
 
Dave Peterson said:
There's a textbox on the drawing toolbar. It's a lot less customizable and
behaves slightly differently.

Maybe a small (er, large experiment!) would help you decide if you could replace
the control toolbox textbox with the drawing toolbar textbox.
Click to expand...

I´ll try that - but that "small" experiment... a LOT OF WORK ;-)
Thanks for your help!

Greetings,
Tim.
 
Back
Top