LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 230
Default data file size increase

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What cause the file size increase by replacing $L with $U? Eric Excel Discussion (Misc queries) 0 September 4th 07 03:44 AM
File size increase Tania Excel Discussion (Misc queries) 1 January 31st 07 08:26 AM
File size increase Don4908 Excel Discussion (Misc queries) 6 December 22nd 06 08:10 AM
File Increase in size Martinj Excel Discussion (Misc queries) 7 November 7th 05 02:00 PM
File size increase Bill Clark Excel Discussion (Misc queries) 1 January 28th 05 06:57 PM


All times are GMT +1. The time now is 10:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"