Forum Discussion
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?
4 Replies
Make sure that:
1) Calculation Options on the Formulas tab of the ribbon is set to Automatic.
2) You don't see a Circular References warning in the status bar at the bottom of the worksheet window.
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?
