Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Minnesota, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Maximum Number of Worksheets? (Excel 2000)

    Does anyone know if Excel 2000 has a limit on the number of worksheets you can have in a workbook, and, if so, what it is? Can't find it in Help or this Forum.
    Thank you.
    Karnie Moesenthin
    Technical Training and Development Professional
    Legal Industry

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    St. George, Maine, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Maximum Number of Worksheets? (Excel 2000)

    Help with search word 'limitations' gives a selection. Choose 'Worksheet and workbook specifications'.
    This gives:
    Sheets in a workbook _______ Limited by available memory (default is 3 sheets)

    Hope this helps,
    Bob_D

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Los Angeles, California, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Maximum Number of Worksheets? (Excel 2000)

    It looks like you can have as many as you want, as long as you have enough RAM. The "official" specs page on the MS KB site does not state an upper limit.

    http://support.microsoft.com/directory/art...;EN-US;Q264626&

  4. #4
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Minnesota, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Maximum Number of Worksheets? (Excel 2000)

    Thank you, Bob. I appreciate the help.
    Karnie Moesenthin
    Technical Training and Development Professional
    Legal Industry

  5. #5
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Minnesota, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Maximum Number of Worksheets? (Excel 2000)

    Thank you, Van. I forwarded the article to the person with the question, and kept a copy for myself.
    Karnie Moesenthin
    Technical Training and Development Professional
    Legal Industry

Posting Permissions

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