Why size of files getting larger

voodoo · Apr 11th, 2002, 06:51 PM

I have two Excel/Macro files that are almost identical in content (sheets, modules, code etc) but very different in size. One is 815KB, the second is 1490KB.

Can anyone tell me some factors that may influence the size of macro/Excel files. I know that with VB exe files they can grow with use and sometimes need to be recompiled to make them smaller.

Is this a similar thing with Excel/Macro files? Are there any other reasons files may grow with use? Other than the forms, sheets and modules could there be other reasons one file is so much bigger than the other?

Any ideas orsuggestions would be greatly appreciated

Thanks

voodoo

Todd_M · Apr 11th, 2002, 07:06 PM

Depends on what kind of info is being entered? Also depends on which programed is used more.

Tom Schreiner · Apr 11th, 2002, 07:22 PM

Hi

To format an entire column uses the same amount of "instructions file space" as to format one cell

If you are copying and pasting formats in seperate cells, this can increase the size of your file significantly.

Tom

Waxaholic · Apr 11th, 2002, 09:58 PM

I had this problem befor with a large Workbook linked to an outside Database. Trick was to go into Tools>Options>Calculation and Uncheck "Save External Link Values". This cut my file size down to about 1/3 the original. Another thing you can check is highlight/select all cells below and to the right of your work area and do a delete. This will ensure there isn't any stray formatting and data.

Waxaholic

voodoo · Apr 11th, 2002, 11:18 PM

Thanks for the ideas axaholic I give them a try.

Cheers

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 06:51 PM	#1
voodoo Board Regular Join Date: Apr 2002 Location: Australia Posts: 186	I have two Excel/Macro files that are almost identical in content (sheets, modules, code etc) but very different in size. One is 815KB, the second is 1490KB. Can anyone tell me some factors that may influence the size of macro/Excel files. I know that with VB exe files they can grow with use and sometimes need to be recompiled to make them smaller. Is this a similar thing with Excel/Macro files? Are there any other reasons files may grow with use? Other than the forms, sheets and modules could there be other reasons one file is so much bigger than the other? Any ideas orsuggestions would be greatly appreciated Thanks voodoo

Apr 11th, 2002, 07:06 PM	#2
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Depends on what kind of info is being entered? Also depends on which programed is used more.

Apr 11th, 2002, 07:22 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi To format an entire column uses the same amount of "instructions file space" as to format one cell If you are copying and pasting formats in seperate cells, this can increase the size of your file significantly. Tom

Apr 11th, 2002, 09:58 PM	#4
Waxaholic Board Regular Join Date: Apr 2002 Posts: 68	I had this problem befor with a large Workbook linked to an outside Database. Trick was to go into Tools>Options>Calculation and Uncheck "Save External Link Values". This cut my file size down to about 1/3 the original. Another thing you can check is highlight/select all cells below and to the right of your work area and do a delete. This will ensure there isn't any stray formatting and data. Waxaholic

Apr 11th, 2002, 11:18 PM	#5
voodoo Board Regular Join Date: Apr 2002 Location: Australia Posts: 186	Thanks for the ideas axaholic I give them a try. Cheers