number of worksheets

  • Thread starter Thread starter Neia
  • Start date Start date
In EXCEL 2007, according to MS documentation:-

"Limited by available memory (default is 3 sheets)"

Please hit Yes if my comments have helped.

Thanks.
 
While the number of sheets you can have is limited only by memory, the number
of sheets that you should have is limited by practicallity. I will guarantee
you that you will hit your practical limit long before you hit the memory
limit.
 
One more note....................

The maximum number of default sheets for a new workbook is 255

You can add more after the workbook is open............depending upon memory
as others have pointed out.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 0
Macro to create validation list of worksheet names 1
Setting Scope of name ranges to particular worksheet 2
Collate Worksheets into single workbook 3
Insert Page Numbers on Worksheet in Excel 2007 6
Print worksheet 2 on back of worksheet 1, etc.... 1

Back
Top