sumif calculate

[SUMIF]

I used too many "SUMIF" functions in the file.

It is still work. But the status showed "Calculate" made me not confidence.

Do have any solutions ?

 

[Govind]

Hi,

The Auto calculate function is off.

Go to Tools ->Options -> and choose the tab calculation.

Check the Automatic radio button in that tab.

Regards

Govind.

 

[keith]

Calculation takes forever, MS KB Q243495 XL2000:
Calculate Message Remains in Status Bar If 65,536 Formula
References (Xl97 and XL2000),
http://support.microsoft.com/default.aspx?kbid=24349