Home

excel work book the calculation is set to manual, why?

%3CLINGO-SUB%20id%3D%22lingo-sub-580808%22%20slang%3D%22en-US%22%3Eexcel%20work%20book%20the%20calculation%20is%20set%20to%20manual%2C%20why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-580808%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20can%20anyone%20explain%20how%20i%20can%20change%20the%20default%20settings%20for%20a%20new%20workbook%20book%2C%20so%20the%20W%3CSTRONG%3Eorkbook%20calculation%3C%2FSTRONG%3E%20setting%20is%20the%20to%20%3CSTRONG%3EAutomatic%2C%3C%2FSTRONG%3E%20and%20when%20i%20save%20a%20workbook%20the%20setting%20stays%20the%20same.%3C%2FP%3E%3CP%3Ei%20am%20sure%20this%20used%20to%20happen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETIA%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edave%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-580808%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-580883%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20work%20book%20the%20calculation%20is%20set%20to%20manual%2C%20why%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-580883%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F343755%22%20target%3D%22_blank%22%3E%40dcut121%3C%2FA%3E%26nbsp%3B%2C%20settings%20are%20here%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20488px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F114150iBE2FDDAE98A6CB5B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThey%20shall%20be%20the%20same%20till%20working%20with%20the%20same%20or%20any%20other%20workbook%20you%20change%20them%20on%20Manual.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
dcut121
Occasional Visitor

Hi, can anyone explain how i can change the default settings for a new workbook book, so the Workbook calculation setting is the to Automatic, and when i save a workbook the setting stays the same.

i am sure this used to happen.

 

TIA

 

dave

1 Reply

@dcut121 , settings are here

image.png

They shall be the same till working with the same or any other workbook you change them on Manual.

Related Conversations
IF function
qexle in Excel on
2 Replies
Excel Help needed
NojMc in Excel on
1 Replies
IFS with AND and multiple falses
Bradley79 in Excel on
1 Replies
Matching date input to the formatted date display
Erikstg in Excel on
2 Replies