Too many files open, not enough memory

Excel that comes with Office 2000 small business does not work with some of the vb codes writen for it. not sure why and not sure if this is what is causing the problem. if they are in fact using small business, check to see if they can install office premium or stand alone excel.

hope this helps.

This is an OS problem.
The maximum number of files is still set by default by Win9x .
They need to raise this number in config.sys
The best way to reduce memory usage is to limit the Caches.
Run Cacheman.
It is far superior to Windows for management, and it is shareware. (Unbelievable situation)
It also has a good memory usage graphing function, for diagnosing problems.
Regards, Chris

Hello

If the user is using W2K you could try to increase the default application heap size, which will help eliminate the out of memory message. Before you begin, make sure that the user has a verified backup of the registry, then navigate to:HKLM\system\current control set\control\session manager\subsystems subtree

Find the windows key and modify the SharedSection parameter. Increase it by 512k incrementally until the out of memory error stops. Also, you might want to look at KnowledgeBase Article Q126962

Hope this helps

Mark