File Size oddness

[centprop]

Hi all.

I have what I feel is a really odd problem, hopefully its very straightforward to you guys.

I have a large .xlsm workbook with many sheets, that amongst other things creates various reports based upon a single data set sheet. I copied one of the sheets, and modified it so that the report it creates is slightly different.

I had a little trouble getting it working, with the modified VBA code, but eventually succeeded. I then had to add some stastical information to the bottom of this report, that was calculating percentages based on some of the figures this dynamic report was giving me. This is when I noticed a drop in performance, and it took a while to save. I figured as the data within the report was dynamic, it was causing a slowdown, so I recreated the statistics in another sheet, not using the dynamic report, but the original dataset to produce the figures. I then referenced these new cells from the new report layout, expecting it to be much less intensive, however it didn't help. I then realised that the file size was a massive ~40MB

Just to confirm that the new sheet was the problem I removed it, saved a new version and that now has a file size of 763KB

There is no intensive graphics, or very much going on with this new sheet that I can think of that will be making such a huge difference with the size of it, so what could it be?

What other information can i share with you to help me find out what is going on?

Thanks in advance

Chris

 

[GlennUK]

I'd guess that something in your processing was generating a large used range. Rejigging things seems to have now prevented that happening.