Not Enough System Resources to Display Completely

[RamblinWreck]

I have a spreadsheet with several drop down menus. Depending upon th
screen resolution and/or Percent Zoom, I may get a "Not Enough Syste
Resources to Display Completely" error when I try to access the dro
down menu.

At a screen resolution of 1280 by 1024 pixels and a Percent Zoom of 75
in Excel (or higher), I can access all the drop down menus without an
problems.

If I try decreasing the percent zoom or decreasing the scree
resolution, I start getting the "Not Enough System Resources t
Display Completely" error messages.

I want to distribute this spreadsheet to other people, so it'
important that I understand what is going on.

Can anybody point me in a direction here ?

Thanks in advance

 

[RamblinWreck]

Amazing how a little creative use of the search function will hel
someone answer their own question !

Turns out this is a bug in Excel. Info from a previous post

(http://www.excelforum.com/showthread.php?s=&threadid=210156&highlight=system+resources


is below.

Hope this helps someone else.

Rw.

-------------------

 

[David McRitchie]

Glad you found an acceptable answer.

I would really suggest searching Google Groups to search the
real newsgroups themselves rather than just questions that were
started at ExcelForum and answered mostly in actual newsgroups.

Personally I find placing newsgroup type of forums on web pages
disorienting for real web searches. If I want to search newsgroups
I'd rather search newsgroups for a hint of what I want, and for like
late breaking details, but web pages for an organized presentation.

Hopefully the web search engines will be improved to be able to
choose whether one really wants to include message group type of sites
at all, or whether to include blogs, and whether or not to include dictionaries,
or other word lists.. .

Currently if I do a search with 5 keywords if pulls up a web page
with 25 unrelated threads at ExcelTips or ExcelForum and none of those
threads come even close to what I am looking for, but together they have
all of the keywords.

I could not load your page (active-x), it appeared to get stuck and I'm not
waiting to see if it would actually load if I hit F5 after waiting and waiting.
But I see from the rest of your post that it referred to an actual MS KB article,
so I figure you did well this time.

Anyway to search newsgroups directly would in my opinion be a wiser choice.

Google Groups: Advanced Groups Search
http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100