Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Aug 2001
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Maximum Number of Sheets (2000)

    Hey all, I'm making an application that stores information about several students. I was planning on making a new sheet for each student added and keeping their information in their own sheet.

    I was wondering, how many sheets can be supported and if there would be considerable overhead using this method ? Can anyone think ok another way to store and separate information for several (10-50) students?

  2. #2
    Lounger
    Join Date
    May 2002
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Maximum Number of Sheets (2000)

    According to the Excel Help file:

    Sheets in a workbook Limited by available memory (default is 3 sheets)

    Personally, I would keep everything on one sheet, and then use Data|AutoFilter if I want to focus in on one student, one class, one grade, etc. But that is just my own preference.

  3. #3
    New Lounger
    Join Date
    Jul 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Maximum Number of Sheets (2000)

    If memory serves me correctly, you can have up to 256 tabs, 256 columns and 6300 rows. With that much information, I would use MS Access. You can import your existing data and create a form or report for each individual.

    Hope this helps,

    Dano

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Maximum Number of Sheets (2000)

    To be more precise:

    The maximum number of sheets is 255. In practice, you may run out of memory before you have that many.
    The maximum number of columns in a sheet is 256 (A ... IV).
    The maximum number of rows in a sheet is 65536.

    If you have enough memory, Excel can handle a workbook with 50 or more sheets without problems. But working with them may not be as easy as you like:
    <UL><LI>Finding the sheet for a particular student might be a problem.
    If you right-click the sheet navigation buttons in the lower left corner of the document window, you get a pop-up menu with a list of sheets. If you have many sheets, the last item will be "More sheets...". This displays a dialog that lists all sheets.
    <LI>Excel has no built-in way to sort sheets (apart from moving sheet tabs manually).
    If you do a search on this Forum, you'll find macros and/or links to sort sheet tabs.[/list]Regards,
    Hans

  5. #5
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Memphis, Tennessee, USA
    Posts
    243
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Maximum Number of Sheets (2000)

    Kevin, you shouldn't have a problem doing that if you have a decent computer. Excel easily handles 50+ sheets if your machine can.

    In fact, you can have as many sheets as you want. <img src=/S/shocked.gif border=0 alt=shocked width=15 height=15> I know the help file says 255, but that's referring to a DEFAULT workbook. I have a workbook in the old version 97 with over 400 sheets! So, it CAN be done.

    But, just because you CAN doesn't always mean you SHOULD. <img src=/S/nope.gif border=0 alt=nope width=15 height=15> Like the other poster, I prefer to dump all my data into one huge table and then use Excel features to extract the information as I need it. This is a database concept and gives me more convenience, versatility, and power.

    -Lenny

Posting Permissions

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