May 21 2022 09:04 AM
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.
May 21 2022 09:10 AM
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.
May 21 2022 09:33 AM
@Hans Vogelaar 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
May 21 2022 10:05 AM
SolutionNo, 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?
May 21 2022 11:21 AM
May 21 2022 10:05 AM
SolutionNo, 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?