Formulas will not update!!

[ahamed]

Hi !!

I have problem with formula not being updated. All my excel file has this problem and when ever I update my excel workings the totals or any other formulas given doesn't update itself. Always I have to go to the formula and double click and enter, it to work.

I have checked whether my excel is set to manual calculations and ensured its set for automatic. Even I pressed F9 yet my formulas doesnt get update it self. I have big trouble with this as I have huge file with huge no of formulas.

Pls help me on this

thanx

 

[RoryA]

What happens if you then leave the machine alone for a minute or two? Anything?
If not, it would seem that you have too many formula dependencies and your calculation tree is broken.
I find it hard to believe that that could be the case with every single workbook though as you have suggested.

 

[gbwcpa]

I had the same problem. I set calculation to manual, unchecked calculate when saving, then checked automatic calculation. Seems to be working now.

 

[gbwcpa]

Never mind, I'm still having the problem.