Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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...;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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What cause the file size increase by replacing $L with $U? | Excel Discussion (Misc queries) | |||
File size increase | Excel Discussion (Misc queries) | |||
File size increase | Excel Discussion (Misc queries) | |||
File Increase in size | Excel Discussion (Misc queries) | |||
File size increase | Excel Discussion (Misc queries) |