I know what it states in the specifications and I have done various searches
on the web with very little data to go by on this names issue that I have
ran into. Specifications is one of the first places I go to before I even
start programming as it has to be taken into account in the planning
process. However, based on the symptoms that I been seeing, it looks like
when you reach about 32k names (if truely a binary format number thing, then
it would be either 32767 or 32768 depending on how it's setup), that is when
things starts going bonkers, which I have 512MBs of RAM on the system. It
also doesn't matter if just a minor few things are open or if I have a lot
of things opened, I still get the same result.

Given the symptoms and what I have noticed, it seems as though I'm running
into MS's arbutary limitations again, but only this time with using defined
names.

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000

"FSt1" wrote in message
...
hi
in xl help, type the word specifications.
per specs, number of names in a workbook is limit only by available
resources.
i have never tried to put that may range names in a workbook so i have no
experience on how the workbook would react.

regards
FSt1

"Ronald Dodge" wrote:

WINXPPro, SP2
XLXP, SP3

I have one workbook with 27,144 defined names, when I go to pull up the
properties on the document, it works fine. Another workbook that is
essentially the same thing as far as how it's setup and what it does,
just
the data is different, I have in it, 53,774 defined names, which when
attempting to bring up the document properties, it just hangs, RAM usage
keeps climbing up and have to end the program via the task manager.

Excel opens with base usage of 26MB
Workbook with 27,144 defined names as the only workbook open has the
Excel
object using 48MB (Task Manager) and storage usage is 10.2MB
Workbook with 53,774 defined names as the only workbook open has the
Excel
object using 59MB (Task Manager) and storage usage is 10.6MB
Excel open with no workbooks other than maybe Book#.xls that Excel opens
automatically uses 26MB (Task Manager)

This is just one more thing that has me questioning if I really have ran
into a limitation of the number of defined names one can use within Excel
(almost all of these names are being used for ranges)

--

Sincerely,

Ronald R. Dodge, Jr.
Master MOUS 2000