ExcelBanter - Calculate mode

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Calculate mode (https://www.excelbanter.com/excel-discussion-misc-queries/136652-calculate-mode.html)

dak

Calculate mode

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?

caj

Calculate mode

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?

All times are GMT +1. The time now is 06:56 PM.