Excel File Size Issues

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?

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@discussions.microsoft.com> wrote in message
news:AA59AB1B-1469-4711-81B3-3528D35EF2BA@microsoft.com...
>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?

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

"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@discussions.microsoft.com> wrote in message
> news:AA59AB1B-1469-4711-81B3-3528D35EF2BA@microsoft.com...
> >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?
>
>
>

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

Patrick Schmid
--------------
http://pschmid.net

"jwillert" <jwillert@discussions.microsoft.com> wrote in message
news:09240058-C221-4527-80B7-5BA5AA31C82F@microsoft.com:

> There are no pictures or anything. Just thousands of rows of data multiplied
> by a several sheets.
>
> "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@discussions.microsoft.com> wrote in message
> > news:AA59AB1B-1469-4711-81B3-3528D35EF2BA@microsoft.com...
> > >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?
> >
> >
> >

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@discussions.microsoft.com> wrote in message
> news:AA59AB1B-1469-4711-81B3-3528D35EF2BA@microsoft.com...
> >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