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 ?