sumif calculate
 

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 ?

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.

SUMIF wrote:

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 ?

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=243495


--
keith
------------------------------------------------------------------------
keith's Profile: http://www.excelforum.com/member.php...o&userid=16242
View this thread: http://www.excelforum.com/showthread...hreadid=275543