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.
