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
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
Handling Teams latency
voonsionglum in Teams Developer on
0 Replies
Is there any professional support for my Smart Index?
JUSER-C in Excel on
0 Replies
Sort/filter cells with picture
Drin365 in Excel on
7 Replies
Copying random selection
eiregobra in Excel on
5 Replies