Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Max. sheets in workbook?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does anyone know the maximum number of sheets a workbook can contain? (Excel 2000)

    Cheers

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    this has now real limit bat will crash if to many that you pc cant hadle.

    all down to resorce allocation what is counter balanced but OP system v's and version of Excel applications running and the power resources the pc has.

    NT Technoligies willperforme best as they can counter the didty memory issues in superior mannmo rto domestic windows..

    just to keep it simple ill stop there let me know if you need more


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  3. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    This is limited by the amount of available memory. I think the maximum number if sheets in a default workbook is 255.

    You can keep adding sheets until your computer quits.

    Jay

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks guys. I am running Win2000 and have heaps of memory.... I'll just keep adding sheets and see what happens!!!

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Win 200 nice if excel 2000 or poss XP, i would go good for hundreds, but REMENMBER back up always so no crying later

    if sheets are light more is nasty heavy and book size over 5mb be careful... 10mb NASTY....

    just some points... i always keep excel light and good looking after all she fancys me if im good to her, and im ugly!

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Try this and keep doing it until Excel crashes, if you want a fast way to test your system

    Sub New_Sheets()
    Dim intNumber As Integer, Counter As Integer
    intNumber = _
    Application.InputBox("Create how many sheets?", "Number of new sheets", "300")

    Application.ScreenUpdating = False
    For Counter = 1 To intNumber
    Worksheets.Add
    Next
    Application.ScreenUpdating = True
    End Sub

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •