Excel 2017 not auto calculating some rows in a sheet

[mdefr]

Hi all

Having a problem with a tab in my excel workbook that doesn't autocalculate some rows.
The equations in those rows are valid but they do not update when the data they are reading from is changed.
Pressing calculate now doesn't update the result of the equation either.

The only way I have found to update the result is to change the equation from divide by 100,000 (in this example) to a different number
and then change it back to (100,000). Any ideas on what's wrong?

This has me worried about whether it is systemic within my sheet or even this version and I will need to check all other tabs.

Current version: Excel 2017

 

[=ODIN=]

Does hitting [ctrl + alt + f9] make them recalc (this recals everything)? also, have you checked that you have no circular reference errors (these some times cause weird issues)?

 

[mdefr]

Does hitting [ctrl + alt + f9] make them recalc (this recals everything)? also, have you checked that you have no circular reference errors (these some times cause weird issues)?

Actually, it does. Surprisingly. Is it an issue to do with there being out of workbook links that weren't updated on opening?

 

[=ODIN=]

Sorry, without seeing the exact situation, I can't tell whats's wrong. My best is advice is to definitely look at what is different about the formulas that don't recalc (start with those in the most upper left), and also once again double check the circular references.

 

[Peter_SSs]

Welcome to the MrExcel board!

Your thread title says Excel 2017. I assume that is a typo or you just meant that you have the latest version through Office 365?

In any case, see if this link helps with the below issue.

Is it an issue to do with there being out of workbook links that weren't updated on opening?