Re: Excel File Size Issues


Jeff Standen wrote:
That is a crazy size. Do you have some big pictures or objects in your
workbook? I think the code itself is unlikely to take up that kind of space
unless there is really loads of it (like hundreds of forms/modules).

Jeff

"jwillert" <jwillert@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AA59AB1B-1469-4711-81B3-3528D35EF2BA@xxxxxxxxxxxxxxxx
I am currently doing some excel programming and my current file has become
unreasonably large (120+ MB) and excel is slowing down and freezing at
times.
It should not be an issue with either my computer or memory, as they are
both sufficient. Is there any way to speed up macros or any tips on
cutting
down on unneccessary code?

Not a crazy size if it contains thousands of lines, as the poster says
later, in multiple sheets. I admit I never got quite 120Mb, but I
reached almost 100Mb with less than 10 sheets. Each sheet contained
anything between 10-22 thousand lines, and up to 40-50 columns.
These files become slooooow to open.

I no longer use excel to work with large sheets like that, and I'd
rather use R (for programming), and only Excel at the last stages to
display (smaller) tables and simple operations. Much faster.

Jose

.