Formulas not automatically updating

[Palmerama]

Morning All,

So my FD is having an ongoing issue with formulas not updating automatically within a spreadsheet. The key symptoms are that Excel simply chooses not to automatically calculate a cell with a formula when a corresponding cell is changed. This can be sporadic and sometimes is works and others it does not. Further to this is you press F2 on the cell containing the formula and press enter it of course updates the total.

As you can imagine he is getting rather cross as this could lead to large financial mistakes.

I have tried to give as much additional detail as possible below:

• Excel version - 2303 (Build 16227.20280)
• Windows 10
• File is fairly large in size 30mb and contains 10+ tabs but nothing major
• Certain cells are formatted using a custom type for certain financial calculations - 0 ;(0);" - "
• Others are mainly just formatted as a number
• Calculation options are set to automatic
• We have tried moving the file to different locations - Running locally from the PC, from OneDrive, from shared network drive
• PC its running on is very powerful workstation with i7 processor and 32gb RAM

At the moment I am at a loss on how to fix this so any help or suggestions would be much appreciated.

 

[FormR]

Hi, welcome to the forum!

Is it just one particular formula in one particular workbook?

Did you check for any circular reference errors?

 

[Palmerama]

Hi, welcome to the forum!

Is it just one particular formula in one particular workbook?

Did you check for any circular reference errors?

Hi,

Thanks for the reply, there are no circular reference errors that we can see and the issue appears to be across more than one file and not just one file which is why we are at a loss.

Formulas are really simple as well such as =SUM(ABG26:ABG29)

 

[offthelip]

you could try rebuilding the dependencies chain by typing Ctrl+Alt+Shift+F9
see:
Excel Recalculation

 

[FormR]

Do the affected workbooks behave as expected on other PC's? i.e. could it be a problem with the specific PC or the office install on that PC?

 

[Palmerama]

you could try rebuilding the dependencies chain by typing Ctrl+Alt+Shift+F9
see:
Excel Recalculation

Will give this a try thanks

 

[Palmerama]

Do the affected workbooks behave as expected on other PC's? i.e. could it be a problem with the specific PC or the office install on that PC?

I will be honest I haven't seen it behave in this way for anybody else and not on my PC however we have tried several new PC's and office re-installs

 

[FormR]

If you open Excel in safe mode (hold CTRL whilst opening opening the application) does it resolve the problem?