check that tools-options-calculation is set to automatic

"Corinnak" wrote:

I copied a whole workbook with formulas, but I have to double click each and
every cell that has a formula in order for it to update. Is there a shortcut
to updating every formula in an entire workbook?