Thread: Is there a maximum of the number of worksheets in a workbook?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
  
Posts: 320
Default Is there a maximum of the number of worksheets in a workbook?
Limited by memory. Maximum DEFAULT number in a new worksheet is 256. I've
created workbooks with over 4000 sheets (just to see if I could!)
Bob Umlas
Excel MVP

"CYNTHIA" wrote:

I want to make worksheets for the entire yr of 2007 in a workbook by doing
it weekly.

How many worksheets are allowed in a workbook or is it indefinate?
Reply With QuoteReply With Quote