What slows down Excel

[mkw4949]

i have a general question about the type of formulas that will slow excel down and inflate the file size. For example from what I've heard using an arrey formula will generally (i.e. sumproduct, sumif or anything inside []) slow down you spread sheet but will it also increase the file size? What about the Offset formula? If I use ALOT of Offset functions will that severely impact my spread sheets performance. And I do mean ALOT as in thousands.

Also what directly impacts the file size and how can I better manage this? I am a pretty advanced user and I've looked in books but have not found the answer. I would greatly appreciate any help. Thanks.

 

[Stormseed]

so file size is strictly a function of the number of characters contained in the file. Does this mean that if your file references another worksheet in the same file you will increase the file size as well? For example does “A1” take up less space then “Sheet1!A1”?

In accordance with the points mentioned above, your file size would increase considerably with using cell colors and most importantly borders as well. Moreover, my personal experience - Excel file size will zoom up when you use Array Formulae over large ranges. Another problematic function is OFFSET(). Try not to use it or your will experience problems later on..also, replacing OFFSET() with INDEX() is a very wise decision, I should say that too ! It does help extensively for faster calculation and also reduces the file size.