Excel File Size Issues

J

jwillert

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?
 
J

Jeff Standen

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
 
J

jwillert

There are no pictures or anything. Just thousands of rows of data multiplied
by a several sheets.
 
P

Patrick Schmid

Does the file become any smaller when you use File, Save As and save it
under a new file name?

Patrick Schmid
 
J

Jose McNach

Jeff said:
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
Click to expand...

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
 
Top