Tools - Options - Calculation - Automatic
--
HTH...

Jim Thomlinson


"Amy" wrote:

When I am in a spreadsheet and I drag a formula down it does not calculate
unless I double click. What is going on? This has just started happening
and not sure how to fix.

Thanks