Try the menu choices Tools | Options | Calculation . There are several
options there for controlling recalculation of the worksheet.

John
www.JohnMichl.com