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
Highlighted

@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
Version 2001 Excel 365 and no Dynamic Arrays
MilesWilliams in Excel on
5 Replies
$ symbol changes format of cells automatically
gbetar01 in Excel on
2 Replies
Excel table formatting best practices question
Jerry1385 in Excel on
2 Replies
If/Then Formula Not Drawing Across Sheets
Matt010614 in Excel on
2 Replies
FREQUENCY
enaugle in Excel on
3 Replies
how to calculate sum of the previous months by company
gorandimeski in Excel on
1 Replies