Prev: Data aggregation with multiple workbooks
Next: Itemize a colum and fill down
From: Kadco on 10 May 2010 14:41
We have a workbook with simple if and sumif and countif statements. The
workbook files size seems to keep growing. Currently at 88MB. What would
cause this?
--
Kad
From: Gord Dibben on 10 May 2010 16:28
Many things can cause workbook creep but you don't give much detail.

I would suggest you first go to Debra Dalgleish's site for some info on
clearing up your used range on each sheet.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

On Mon, 10 May 2010 11:41:01 -0700, Kadco <Kadco(a)discussions.microsoft.com>
wrote:

>We have a workbook with simple if and sumif and countif statements. The
>workbook files size seems to keep growing. Currently at 88MB. What would
>cause this?

From: Martin Brown on 10 May 2010 17:15
Kadco wrote:
> We have a workbook with simple if and sumif and countif statements. The
> workbook files size seems to keep growing. Currently at 88MB. What would
> cause this?

I am a bit surprised SUMIF & COUNTIF cause this trouble. Orphanned
bulky metadata from drag and drop operations can do it as can ADO.
Particularly in an environment where the document is passed between
different versions of Excel. IME it requires images like JPEG, GIF or
BMP to be involved before you get insane file size increases occurring.
Take a look at MSKB eg

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q293828

It can be informative to export the thing as an HTML file and take a
careful look at whatever other dross is lurking in there.

I tend to see more issues with Word than Excel myself.

Regards,
Martin Brown
 | 
Pages: 1
Prev: Data aggregation with multiple workbooks
Next: Itemize a colum and fill down