Spreadsheet Size Problems

[kim.miller2]

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]

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

 

[kalukaley]

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

Next time I'll pay closer attention.

 

[macropod]

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

 

[OfficePlayer]

test