Results 1 to 11 of 11
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Workbook Limit (Excel 2000)

    I am having problems working with a workbook with multipl spreadsheets + pivot tables that is about 12,000kb. I have heaps of memory etc but have been told that Excel has limits on how big a file can be before it starts going troppo - is this true? What can I do as I need all these pivot tables.
    Thanks

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

    Re: Workbook Limit (Excel 2000)

    What kind of problems? Normally Xl can handle workbooks like this. I once has a 20 Meg workbook with many charts & formula's on an ancient P100 system with 32 Megs of RAM.

    This is what XL2K OLH says about its specs on pivot tables:

    PivotTable reports on a sheet Limited by available memory
    Items in a PivotTable report 8,000
    Row or column fields in a PivotTable report Limited by available memory
    Page fields in a PivotTable report 256 (may be limited by available memory)
    Data fields in a PivotTable report 256
    Calculated item formulas in a PivotTable report Limited by available memory

    So maybe something else is bothering you?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Workbook Limit (Excel 2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> RFreed

    If some of these worksheets contain formatting, such as ranges of colored background, and these worksheets are not used by the user, try and remove all that formatting and the size will drop a bit.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  4. #4
    New Lounger
    Join Date
    Feb 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook Limit (Excel 2000)

    The workbook has about 6 different pivot tables, and it is the pivot tables which appear to be the problem as when I take them out and move them to another workbook (retaining links) the original workbook decreases dramatically. However, I then have the problems with the pivot table workbook. I have 256RAM so should be no problem. It takes FOREVER to save and will often hang "not responding" and I will have to end task and lose all saved work etc.

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook Limit (Excel 2000)

    That sounds like the workbook may be corrupted. Try saving the workbook in HTML format, close Excel, Start Excel again, Open the HTML file, and then save it as a .xls file again. This may lose some formatting, and I don't know what it will do with the pivot tables, so keep a copy of the original workbook. After manually recreating anything that was lost in this process, see if you still have problems.
    Legare Coleman

  6. #6
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook Limit (Excel 2000)

    You might also try saving as an Excel 97 workbook...Brooke once saved my bacon by doing the same. Filesize went from 3 megs to 2 megs after the procedure.

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

    Re: Workbook Limit (Excel 2000)

    There is no such thing as saving as 97 workbook format. You may have meant to write as 5/95 format?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook Limit (Excel 2000)

    Actually, I meant to save as "Microsoft Excel 97-2000 & 5.0/97 Workbook" and open it with Excel 97. I think this is what Brooke did with mine.

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

    Re: Workbook Limit (Excel 2000)

    Be aware, that curing a disease with that medicine might be worse than the disease itself. That mixed file format is reknown for causing file corruptions!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  10. #10
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Workbook Limit (Excel 2000)

    <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=102927&page=&view =&sb=&o=&vc=1>This</A> is the thread to which Mike is referring. But the basics are that very little would work. The file was 2k but would not open. What I did in the end was to open in 97 (disabled macro's) and saved it. Reopened it in 2k and saved it: This seemed to do the trick - leastways, Mike's not sent me any more help messages!

  11. #11
    3 Star Lounger
    Join Date
    May 2001
    Location
    Kenilworth, Warwickshire, England
    Posts
    269
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Workbook Limit (Excel 2000)

    Jan,

    I picked up your reply when searching for a limit to the number of calculated fileds in a Pivot table. Has anyone pushed back on the "limited by memory"? Before settling on a calculated field solution I proved the calculation work, and I proved dimensions of the tabvle using just a couple of calculatoins and then ordinary "sum of field" stuff.

    Deep consternation now when it cuts off at a limit WAY below what I trialed.

    Different context here, so I will keep testing, but I dont want to chase the imposible dream....

    Thanks
    Mike C

Posting Permissions

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