Not Enough System Resources To Display Completely

  • Thread starter Thread starter Richard
  • Start date Start date
R

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
 
Richard said:
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
Click to expand...

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.
 
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.
 
Back
Top