Spreadsheet Size Problems

I've been working on a XL spreadsheet using VBA Macros and the size of
my sheet has grown by 10 times (1200kb to 12,000kb), and it is very,
very slow. The amount of data processed hasn't grown much. Any idea
what might have caused this? Thanks

kalukaley
Fri Nov 02 14:40:26 PDT 2007

This tends to happen after working for some time in an mdb. Try running the
repair utility. It should do the trick.

Tools \Database Utilities\Compact And Repair Database

"kim.miller2@ngc.com" wrote:

> I've been working on a XL spreadsheet using VBA Macros and the size of
> my sheet has grown by 10 times (1200kb to 12,000kb), and it is very,
> very slow. The amount of data processed hasn't grown much. Any idea
> what might have caused this? Thanks
>
>

kalukaley
Fri Nov 02 14:42:37 PDT 2007

My apologies, for some reason I thought you were using MS Access.

Next time I'll pay closer attention.

"kim.miller2@ngc.com" wrote:

> I've been working on a XL spreadsheet using VBA Macros and the size of
> my sheet has grown by 10 times (1200kb to 12,000kb), and it is very,
> very slow. The amount of data processed hasn't grown much. Any idea
> what might have caused this? Thanks
>
>

macropod
Fri Nov 02 22:35:11 PDT 2007

Hi Kim,

There are many possibilities. Complex array formulae, for example, can create quite a performance hit, especially if their ranges
are unnecessarily large. I suggest asking in an Excel forum - this one's for Word.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

<kim.miller2@ngc.com> wrote in message news:1194016120.640556.190590@d55g2000hsg.googlegroups.com...
> I've been working on a XL spreadsheet using VBA Macros and the size of
> my sheet has grown by 10 times (1200kb to 12,000kb), and it is very,
> very slow. The amount of data processed hasn't grown much. Any idea
> what might have caused this? Thanks
>

OfficePlayer
Tue Nov 06 06:16:44 PST 2007

test
<kim.miller2@ngc.com> schreef in bericht
news:1194016120.640556.190590@d55g2000hsg.googlegroups.com...
> I've been working on a XL spreadsheet using VBA Macros and the size of
> my sheet has grown by 10 times (1200kb to 12,000kb), and it is very,
> very slow. The amount of data processed hasn't grown much. Any idea
> what might have caused this? Thanks
>