Sebastian H
11-11-2010, 02:54 AM
OK, this question has nothing to do with VBA, but I hope it's still OK to ask here, seeing as "Reduce Excel File Size (http://www.vbaexpress.com/forum/../kb/getarticle.php?kb_id=83)" is listed as the top most useful KB entry here (http://www.vbaexpress.com/kb/default.php).
When I sort the attached file thiswillgrow.xls by column A (ascending), it will grow from 33 to 39 KB. This may not seem much, but this is only a small version of the original file, stripped down to the bare bones. The original file grows by about 70%, or 3.3 MB. The growth is very predictable; I compiled a table with different results for different intermediate sizes; if anyone's interested. BTW, I'm using XL 2003 under Win XP.
What makes this even more mysterious is that column A is already sorted. So there's no reason for anything to change in the file.
To reset the file size, proceed as follows: Quit Excel (and save the file, if you like), and then open Excel again and save the file again while it is still unspoiled.
Any idea what causes the growth, and how to prevent it? The file does need to be sorted repeatedly, so not sorting it is not an option.
When I sort the attached file thiswillgrow.xls by column A (ascending), it will grow from 33 to 39 KB. This may not seem much, but this is only a small version of the original file, stripped down to the bare bones. The original file grows by about 70%, or 3.3 MB. The growth is very predictable; I compiled a table with different results for different intermediate sizes; if anyone's interested. BTW, I'm using XL 2003 under Win XP.
What makes this even more mysterious is that column A is already sorted. So there's no reason for anything to change in the file.
To reset the file size, proceed as follows: Quit Excel (and save the file, if you like), and then open Excel again and save the file again while it is still unspoiled.
Any idea what causes the growth, and how to prevent it? The file does need to be sorted repeatedly, so not sorting it is not an option.