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

@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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies