Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    May 2003
    Location
    Alexandria, Virginia, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel file bloat (Excel 2000 SP-3)

    I'm researching a problem for a friend and am looking for a basic place to start. She has an Excel workbook with approximately 15-20 worksheets. Nothing fancy... or at least, not at first glance... basic data sheets on all but one worksheet, and a simple chart on the last. The file size used to be in the 4-5 MB range, but has recently grown to a whopping 46 MB! Initial web research has indicated that Excel file bloat is not uncommon... are there any standard things I should check that could help reduce this workbook back to its former size? Thanks in advance for any tips.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts

    Re: Excel file bloat (Excel 2000 SP-3)

    Is it a 'shared' workbook?

    zeddy

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Tampico, Tamps, Mexico
    Posts
    118
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file bloat (Excel 2000 SP-3)

    Bairman:

    Was the file saved in a previous version?
    example:
    Microsoft Excel 5.0/95 Workbook (*.xls) or
    Microsoft Excel 95-2000 & 5.0/95 Workbook (*.xls)

    This cause that a file grows of abnormal way. Check it

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

    Re: Excel file bloat (Excel 2000 SP-3)

    If you have Excel 2000 or above, then try saving the file in HTML format. Then open the HTML file and save it back as a .xls file. This will sometimes get rid of file bloat. Keep a copy of the original file as this process might cause the loss of formating in the file.
    Legare Coleman

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

    Re: Excel file bloat (Excel 2000 SP-3)

    In addition to the other replies:

    Check each sheet for what XL thinks is the last used cell by pressing control-end. If that takes you way past the end, delete all extraenious rows and columns (rightclick their rownumber/columnletters and choose delete). Then save the file.

    Another thing to check is formatting. Applying a format to a whole row or column does not increase filesize much, but applying to almost all cells in a row/column will.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,826
    Thanks
    136
    Thanked 482 Times in 459 Posts

    Re: Excel file bloat (Excel 2000 SP-3)

    From the whopping increase you report my initial reaction is that the workbook is shared and the 'track changes' option is set. This can cause such an increase. Maybe you could turn off or adjust the 'track changes' setting.

    zeddy

  7. #7
    New Lounger
    Join Date
    May 2003
    Location
    Alexandria, Virginia, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file bloat (Excel 2000 SP-3)

    Thanks to all who responded to my post. The suggestions that were offered didn't work themselves, but they set me on the right troubleshooting path toward the solution. It turns out that the very first worksheet caused the bloat. I still don't know exactly why it happened, but deleting that worksheet and recreating it reduced the file size from 46 MB to 525 KB. Problem solved... thanks again. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

Posting Permissions

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