Method 5 – Excel Formula Not Updating Due to Manual Calculation Mode When Macro is used, Excel can’t update the formula automatically. Steps Check the VBAProject sheet or Module in Visual Basic by pressing Alt
If you've gone through the above three-step check and removed unnecessary cell formatting, styles, and conditional formatting but still work clumsily on a large Excel workbook, you may need to look at the formulas and calculations in your worksheet. You don't have to check every calculation ...