Thread: # of Worksheets
View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default # of Worksheets

This is limited by the resources available on the machine on which the file
is run. However (and I'm sure you'll get different opinions), I would not
personally use more than 30 or 40; perhaps 100 in extenuating circumstances.
Likely, if you explain what you're trying to accomplish, we can provide
better methods.
************
Anne Troy
www.OfficeArticles.com

"Jeanne" wrote in message
...
How many worksheets can be used in one Excel file?