Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, BC
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel file bloat (again) (2000 sp2)

    I read a post from two years ago that complained of a filesize increasing a ten-fold for no understandable reason. My file is used on a home pc (win xp), not shared. The increase happens to me on one file when I save the file, or when I've copied a filtered set to a new worksheet or a new file, but it often doesn't happen. I'd really love to find out what I'm doing that would cause that. I found a whole row that was formatted shaded to the right of the data columns, but some versions where that was the case were the original small size (30kb) and others were 3000kb, and in one version where I deleted all that formatting, the bloating problem occurred. I created the file and have never inserted any pictures or used any vba code or formulas. This is all text data, with auto filtering on the data values. Is there a way I could be inadvertently pasting the filtered data to a new file or worksheet as a picture??

    I've just tried to recreate the problem, which happened earlier today, and am unable to do it. I've selected a filtered subset by selecting the columns and pasted them into a new file, which shows columns extending out to IV (though I selected by clicking on the column letters I'm using, it only goes to six or so rows past the end of the data), and still no bloat. I increased and decreased row heights, added a print area, copying the data to a new workbook, all the things that I've done when the file size bloated on me. In one trial, when I pasted the data, the column widths were all the default size, so I manually readjusted them, thinking that would have been what I'd done, but that was no problem. I tried another time and the paste copied the column widths. I'm sure I did the copy and paste and new sheet request the same way - why does it take an undo and repasting to copy the column widths, or is that just how you get it to copy column widths? Anyway, no bloating. But every day that I've done an update to that file, I've created at least one 3000kb file. At least I know now to always create new file names when I do a save, to make sure I haven't created a monster file out of my good version.

    So the question is, has anyone else had that problem and did you ever figure out what caused it? 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: Excel file bloat (again) (2000 sp2)

    Have you tried copying and pasting just the data and formatting to a new file (copy, paste special values if it has no formulas, then paste special formats)? It might be there is a hidden corruption somewhere in the file that is causing this trouble.

    Also, round tripping the file through HTML might remove potetnial problems.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, BC
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel file bloat (again) (2000 sp2)

    Thanks, Jan. I have managed to start over with my copying and not get the big files. And tonight, when I was trying to get a big file so I could test the save as htm trick that I had read about, I wasn't able to get a bloated file. I tried it on a small file and it didn't destroy the formatting or anything, so if that will work, it's certainly the easiest fix I can do to a file that's otherwise just the way I want it. If the problem is just mysterious corruption or a flaky version of Excel, I suppose there's nothing I can learn to do about it, but if there was something I was doing that caused the file to increase in size like that, I wanted to learn not to do that.

Posting Permissions

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