Cells not auto updating in excel
If a workbook is set for automatic recalculation, you do not need to press F9 for recalculation.
Note Solver and Goal Seek are part of a suite of commands sometimes called what-if analysis tools.
As calculation proceeds, you can choose commands or perform actions such as entering numbers or formulas.
Excel temporarily interrupts calculation to carry out the other commands or actions and then resumes calculation.
Both commands use iteration in a controlled way to obtain desired results.
You can use Solver when you need to find the optimum value for a particular cell by adjusting the values of several cells or when you want to apply specific limitations to one or more of the values in the calculation.
You type in a function and when you press Enter, the cell displays the actual function text, instead of calculating the function's value.
This problem often arises because the cells containing the formula are formatted as 'text' instead of the 'General' type.
To correct this, you need to convert the cell's data type to the 'General' data type.
Try pressing the keyboard shortcut CTRL-`, to see if this causes the formula to display its calculated value.
If this does not solve your problem, press CTRL-` again, to return the "Show formulas in cells instead of their calculated results" option to it's previous setting.
By default, Excel will recalculate its functions every time a cell value changes.
However, the Calculation option can be set to switch off automatic recalculation, and once switched off, it is very easy for the user to forget about this option.