Not enough resources..

A

Aranna

I have created an excel sheet with some rather simple
comboboxes, command buttons etc...

I get a message saying "Not enough resources to display
completely" often now, when I click on these comboboxes.

I have over 512MB or ram and lots of room on the HD.
What is going on anyone knows? I tried it on my other
laptop, running a different version of Windows, different
make of laptop etc.. and i get the same message too.

Thanks
 
G

Gord Dibben

Aranna

I enclose below a quote from Ron Martell(MS MVP Windows) regarding "system
resources". Makes for some enlightening reading.....Resources vs RAM.

Gord Dibben Excel MVP

***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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top