View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default Is 300,000 Named Ranges going to cause problems?

yes, performance will be very slow. 300,000 named ranges is not a good idea.
You can probably reduce the number of named ranges by a large factor by
using implicit intersection.

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

wrote in message
oups.com...
I've already posted about a similar issue with creating the named
ranges and have successfully created all 300,000 needed for a
particular project I am working on...however, is having 300,000 named
ranges going to result into performance issues with Excel at some point?