Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
System Resources
I've developed a fairly large workbook in excel that has
about 8 worksheets and about 10 userforms. The largest userform (about 97 activeX controls on the userform) is now giving me trouble. Specifically, when I click on almost any of the combo boxes, I get the following message in an excel message box: "Not enough system resources to display completely." I am working on a Dell Pentium 4, 2.4 mhz machine with 512k ram. Any help on this issue is greatly appreciated Frank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
System Resources
Unfortunately, this is a long-standing problem with ComboBoxes. On
worksheets you can generally fix the problem by adjusting the zoom factor. I don't know of a solution for UserForms. I would suggest, though, that 97 ActiveX controls on a single UserForm is asking for trouble. -- Vasant "Frank" wrote in message ... I've developed a fairly large workbook in excel that has about 8 worksheets and about 10 userforms. The largest userform (about 97 activeX controls on the userform) is now giving me trouble. Specifically, when I click on almost any of the combo boxes, I get the following message in an excel message box: "Not enough system resources to display completely." I am working on a Dell Pentium 4, 2.4 mhz machine with 512k ram. Any help on this issue is greatly appreciated Frank |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
System Resources
On Tue, 25 Nov 2003 19:03:45 -0800, "Frank" wrote:
"Not enough system resources to display completely." I am working on a Dell Pentium 4, 2.4 mhz machine with 512k ram. Any help on this issue is greatly appreciated Frank I enclose below a quote from Ron Martell(MS MVP Windows) regarding "system resources". Makes for some enlightening reading.....Resources vs RAM. HTH Gord Dibben XL2002 ***Start Ron Martell Quote*** System Resources refers to two 64K blocks of memory that Windows allocates to programs for tracking purposes. These blocks are called User Resources and GDI Resources respectively and Windows reports whichever has the least available free space as the value for "Free System Resources". The value of Free System Resources should not be a concern unless and until you start getting "System Resources are getting low" type warning messages, which generally happens at about the 10% level. In test circumstances it has been shown possible for a computer to operate at full performance with System Resources showing zero percent free. System Resources are totally unrelated to the amount of RAM installed in your computer and adding more RAM will not affect the System Resources (unless you start running more applications because you have more RAM). System Resource usage is determined by the number and type of applications that you have running on the computer. Certain types of applications have been shown to be especially demanding in terms of System Resource usage: - "Eye and Ear Candy" such as Active Desktop View As Web Page, sound effect schemes, animated mouse cursors and desktop icons, and fancy screen savers. - Web browsers, as each open browser window requires additional resources. - Multimedia applications of all types - System monitoring utilities such as Norton SystemWorks. If you are running any 16 bit applications (DOS or Windows 3.x) then Windows 95/98 will treat the System Resources allocated to all of these applications as one block and will not release any of them for reuse unless and until all of the open 16 bit applications have been closed. Also, when an application is loaded it is quite common that it will also require some additional Windows components to be loaded as well. However, when that application is closed Windows will, by design, retain the Windows components because they are likely to be needed again. Therefore the resources initially allocated when an application is opened will not all be released when that application is closed. Most, but not all. Hope this explains the situation. Good luck. Ron Martell Duncan B.C. Canada ***End Ron Martell Quote*** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
System Does not have enough resources to display | Excel Discussion (Misc queries) | |||
not enough system resources | Excel Discussion (Misc queries) | |||
no enough system resources | Charts and Charting in Excel | |||
Excel, System resources | Setting up and Configuration of Excel | |||
"The system is dangerously low on resources" | Excel Discussion (Misc queries) |