LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 130
Default Excessive Defined Names Causing Book Properties not to work properly

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
User Defined Function Causing Problems Steve Excel Discussion (Misc queries) 11 December 21st 06 12:18 PM
User Defined Function Properties Brad Excel Programming 3 November 21st 05 02:41 PM
getting the sheet names present in a work book???? Reny J Joseph Thuthikattu Excel Programming 2 December 12th 04 05:30 AM
Change Path names in copied work book jheaney Excel Worksheet Functions 2 November 18th 04 07:29 PM
Range with odd column names causing problems Andy Excel Programming 3 October 22nd 04 10:09 AM


All times are GMT +1. The time now is 12:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"