On main menu Click
Tools -- Option -- Calculation -- Manual

"dak" wrote:

When I am updating large [250-300 MB] files, Excel sometimes goes into a
Calculate mode. The warning "Calculate" appears in the status bar at the
bottom of the pane. Is there a way to turn off this Calculate mode, other
than exiting out of and restarting Excel?