Results 1 to 6 of 6
  1. #1
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel Maximum Sheet Count (2003 or 2007)

    Add-ins cannot increase the maximum sheet count, which is still limited only by available memory, and has been since at least Excel 2000, AFAIK.
    Regards,
    Rory

    Microsoft MVP - Excel

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Maximum Sheet Count (2003 or 2007)

    Can anyone tell me if this site: CPAN is an addin to Excel? I was out looking for changes in Excel 2007 today (trying to verify that the maximum sheet count for Excel 2007 is 256 like it is for Excel 2003), when I came across this page that says it can have more...many more! Is this an add-in they are talking about or have I been assuming wrong info all these years? What is the maximum sheet count in a new Excel 2007 workbook without an addin?
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel Maximum Sheet Count (2003 or 2007)

    No, as far as I am aware there is no relationship between 256 and the number of sheets you can have.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Excel Maximum Sheet Count (2003 or 2007)

    That's just the default number of sheets in a new workbook. You can still insert or copy sheets well beyond that number.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Maximum Sheet Count (2003 or 2007)

    So...256 is not the limit? If you have 1G of memory is 256 the limit, and if you have more memory (double like 2007) can you have more (like 400)? If you try to add more then 255 in Excel 2007 it says that 255 is the limit. How would anyone get more then 255 if you can't type more then 255 into the dialog box? Note picture attached. Is the link from the prior post I gave from CPAN using Perl, and is this the only way to get more sheets, to actually write a program (like with Perl) to do so?
    Attached Images Attached Images
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  6. #6
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Maximum Sheet Count (2003 or 2007)

    Wow...I just did it. I feel so dumb. I thought that the 255 was the max, and that is why everyone has been hollerin' for Microsoft to build bigger worksheets...because of the worksheet limit. There is no limit except Memory...I learned a great deal today, though I wish I had been taught this years ago. Thank you
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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