ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   why does excel keep defaulting to manual calculation? (https://www.excelbanter.com/excel-discussion-misc-queries/105803-why-does-excel-keep-defaulting-manual-calculation.html)

Ruth

why does excel keep defaulting to manual calculation?
 
I have not changed any settings on my computer and for some reason excel
keeps changing my options in excel to manual calculation instead of
automatic. Why is this?

Niek Otten

why does excel keep defaulting to manual calculation?
 
Maybe you have a workbook already open that has calculation set to Manual.
Calculation is an Excel-wide setting, set by the first opened workbook until manually changed.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ruth" wrote in message ...
|I have not changed any settings on my computer and for some reason excel
| keeps changing my options in excel to manual calculation instead of
| automatic. Why is this?



Ruth

why does excel keep defaulting to manual calculation?
 
I'm not sure that is what is causing the problem because the only workbooks I
have open are ones that I have created myself and I never knew the option to
switch off automatic calculation existed until this problem arose! Any
other suggestions?

"Niek Otten" wrote:

Maybe you have a workbook already open that has calculation set to Manual.
Calculation is an Excel-wide setting, set by the first opened workbook until manually changed.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ruth" wrote in message ...
|I have not changed any settings on my computer and for some reason excel
| keeps changing my options in excel to manual calculation instead of
| automatic. Why is this?





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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com