Check out this link

http://www.decisionmodels.com/calcsecretsf.htm
--
HTH...

Jim Thomlinson


"peyman" wrote:

hi,
I have a worksheet with ten worksheets and in some of the worksheets there
are simple formulas and two worksheets with array formula.from a couple of
days age something is wrong with the file, whenever I put any data in any
cell after clicking ENTER , the "calculating cell ..." comes at the bottom of
the sheets and it's driving me crazy!.plz let me know how I can get rid of
the calculating cell... .I had some macro that was written by me but I
removed all of them.
thanks,