SOLVED

Excel does not calculate correctly

Copper Contributor

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.

 

wm_riley2_0-1653148983351.png

wm_riley2_1-1653149036682.png

 

 

4 Replies

@wm_riley2 

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.

@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

 

wm_riley2_0-1653150621772.png

wm_riley2_1-1653150670855.png

 

 

best response confirmed by VI_Migration (Silver Contributor)
Solution

@wm_riley2 

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!
1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@wm_riley2 

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?

View solution in original post