Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2005
    Location
    Columbus, Ohio, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Worksheet Limit? (Excel 2002)

    I have merged 2 excel files and there are now 21 work sheets in the file. I go to save the file, it begins to save and then an error message pops up "Document Not Saved." Is there a limit to the number of work sheets that can be created and saved in a workbook?

    Here goes Microsoft's answer from their web site: Sheets in a workbook: Limited by available memory (default is 3 sheets)

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

    Re: Worksheet Limit? (Excel 2002)

    Twenty-one worksheets is not much in itself. Could there be a conflict between sheet names and/or named ranges?

    Perhaps the workbook has become corrupted. You could create a new merged workbook from the two original ones to see if the problem recurs.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet Limit? (Excel 2002)

    21 is not too much, but of course this also depends on what is IN the sheets.

    See my site:

    http://www.jkp-ads.com/Articles/CorruptFiles.htm for some pointers, especially the part at the bottom of that page about saving as html should be of interest to you.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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