Automatic calculation problem

[papa]

My spreadsheet was working fine for weeks and now will not Automatically calculate for certain sheet rows!! I have been through all the tutorials and its not an issue of turning on the Automatic calculation. I have tried changing the number from Custom to Number, etc. doesn't work

Please help!

[Paul_Hossler]

It's a little hard to guess without having the spread sheet to look at

[offthelip]

I would try forcing Excel to rebuild the dependency tree and the calculation chain. To do this key: CTRL ALT SHIFT F9