Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default How many named cells

Hello,
In excel 2003,
is there a limit to the number of named cells or named ranges you can
create?

thx


  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 968
Default How many named cells

there is no real limit that I know of, but things can get a bit slow if you
get above 5-10000 names.

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"greg" wrote in message
...
Hello,
In excel 2003,
is there a limit to the number of named cells or named ranges you can
create?

thx




  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default How many named cells

this was all i could find, check out this link

Names in a workbook Limited by available memory

http://office.microsoft.com/en-us/ex...992911033.aspx


--


Gary


"greg" wrote in message
...
Hello,
In excel 2003,
is there a limit to the number of named cells or named ranges you can
create?

thx




  #4   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default How many named cells

Does that mean 5,000 to 10,000 names?

(I bet it does. 5 names probably won't hurt <bg.)


Charles Williams wrote:

there is no real limit that I know of, but things can get a bit slow if you
get above 5-10000 names.

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"greg" wrote in message
...
Hello,
In excel 2003,
is there a limit to the number of named cells or named ranges you can
create?

thx



--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
external usenet poster
 
Posts: 968
Default How many named cells

yup <g


"Dave Peterson" wrote in message
...
Does that mean 5,000 to 10,000 names?

(I bet it does. 5 names probably won't hurt <bg.)


Charles Williams wrote:

there is no real limit that I know of, but things can get a bit slow if
you
get above 5-10000 names.

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"greg" wrote in message
...
Hello,
In excel 2003,
is there a limit to the number of named cells or named ranges you can
create?

thx



--

Dave Peterson



Reply
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
Unnaming cells already named Learning Excel Excel Discussion (Misc queries) 6 January 13th 08 08:38 PM
Excell named cells or labeled cells question [email protected] Excel Programming 8 June 25th 06 05:15 PM
Excel named cells or labeled cells question [email protected] Excel Programming 2 June 25th 06 04:39 PM
inserting a named range into new cells based on a named cell Peter S. Excel Discussion (Misc queries) 1 June 4th 06 03:53 AM
same Named cells in different sheet Pierre Excel Discussion (Misc queries) 5 August 19th 05 08:16 AM


All times are GMT +1. The time now is 01:00 AM.

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

About Us

"It's about Microsoft Excel"