Go to ToolsOptionsCalculate and change from Manual to Automatic

"TxVics" wrote:

Has anyone had a problem where dragging a formula down, and the new cells
display the value from the original cell even though the formula itself is
correct? If I clear the cell and reenter the formula, it calculates
correctly.

Thanks!