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
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
Excel on iPad
Mattlewis in Excel on
2 Replies
Help with excel
Alexvez01098 in Excel on
10 Replies
Rotate data from single cell to vertical listings
WEI_Bob in Excel on
2 Replies
2 Seniority Lists
Aminam20 in Excel on
9 Replies
Conditional formatting with wildcard
Rajeev_Raghavan in Excel on
2 Replies