Forum Discussion
Excel does not calculate correctly
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?
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?
- That fixed it. i can't believe I missed that. Good Call!