Not Enough System Resources To Display Completely

[Richard]

I get the warning 'Not Enough System Resources To Display
Completely' come up when i use drop down boxeds on my
spreadsheet.

Its not a very big workbook - 14 tick boxes, three drop
downs, and a number of lookup tables.

WWhay would it have insufficient memory? I've tried it on
several machines, and it happens on each of them, so its
definitley a spreadsheet problem, not a hardware one.

Can anyone help?
Rich

 

[Quaoar]

I get the warning 'Not Enough System Resources To Display
Completely' come up when i use drop down boxeds on my
spreadsheet.

Its not a very big workbook - 14 tick boxes, three drop
downs, and a number of lookup tables.

WWhay would it have insufficient memory? I've tried it on
several machines, and it happens on each of them, so its
definitley a spreadsheet problem, not a hardware one.

Can anyone help?
Rich

Resources are not RAM. Resources are stack pointers to things in
Windows that the OS keeps to find things like the objects on a
worksheet. Freeing resources is accomplished by:

Empty C:\Windows\temp. Run Disk Cleanup or delete temp internet files
with IE or control panel Internet settings (I forget what it is called
in Win9x). Minimize desktop icons and files. Clean up C:\, just the
files in the root of C:; leave the system files and move or delete log
files and other files stored here. Do not use any desktop wallpaper or
screen saver. Reduce the fonts folder to 30-40 fonts. From
Start/Run/type: msconfig [enter]. When msconfig opens, select the
startup tab. Find osa.exe, the so-called Office startup application and
uncheck the box. Close msconfig. If using the Office Bar, disable it,
or at least close it before opening any Office application. It is a
resource hog of the worst kind.

Reboot with the changes and you should be good to go. You can run
Resource Meter Start/Programs/Accessories/System Tools to keep track of
available resources. With just the desktop showing, there should be
70-80% free resources.

 

[Tess]

Richard:
Try disabling "find fast" which eats up resources, plus
other non-essential programs. Control-Alt-Delete on the
desktop & deselect it. Then re-save the workbook using a
different name with no "forbidden" characters in the title.