Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
User Defined Function Causing Problems | Excel Discussion (Misc queries) | |||
User Defined Function Properties | Excel Programming | |||
getting the sheet names present in a work book???? | Excel Programming | |||
Change Path names in copied work book | Excel Worksheet Functions | |||
Range with odd column names causing problems | Excel Programming |