can't figure out what makes excel fast or slow

[kylefoley76]

for ages i have been trying to figure out what makes excel fast or slow. i have some formulas and sometimes it takes about 3 seconds for them to compute and for the cursor to go to the next cell.

well, i just added a new sheet with a chart on it and for some reason that has speeded up my excel enormously. why?

 

[Derek Brown]

I don't know why adding a new sheet should speed calculation but I would guess that only some of the formulas were recalcuating? That is, you did not force a full recalculation of the workbook?
Have a look round the following site to learn more about Excel's calculation methods:
http://www.decisionmodels.com/calcsecretsi.htm