medium10 pts · first answer countsexcelcalculation

Formulas do not update

A colleague changes inputs, but formula results stay the same until he presses F9. What is the likely cause?

A.The formulas are stored as text in the cells, not as formulasB.The workbook was saved as a CSV file by mistake earlierC.Calculation is set to Manual in Formulas > Calculation OptionsD.The inputs are formatted as percentages

Discussion 0

Join free to post in the discussion.

Formulas do not update

Discussion 0

Related questions