Forum Discussion
Solved
Excel does not calculate correctly
i just renewed my Office 365 yesterday and now unable to calculate. Results in 0 and if i copy from the cell above I get the same results from that cell even though it had addtional figures to add. ...
No, don't reinstall.
You DO have circular references. That means a formula that refers (directly or indirectly) to the cell it's in. This prevents Excel from recalculating it.
Select cell F4296 and inspect its formula. Does that provide a clue?
HansVogelaar i appreciate you response and yes they set as you indicated. Since the office was renewed yesterday do you think I need to uninstall and restall? Thanks
No, don't reinstall.
You DO have circular references. That means a formula that refers (directly or indirectly) to the cell it's in. This prevents Excel from recalculating it.
Select cell F4296 and inspect its formula. Does that provide a clue?
- That fixed it. i can't believe I missed that. Good Call!