Excel Formula Calculations Reverting to Manual After I Change to Automatic

%3CLINGO-SUB%20id%3D%22lingo-sub-278509%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Calculations%20Reverting%20to%20Manual%20After%20I%20Change%20to%20Automatic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278509%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20user%20who%20has%20the%20latest%20and%20greatest%20of%20Office%20365%20Office%26nbsp%3B2016%2C%20fresh%20install%20and%20completely%20updated%2C%20after%20she%20started%20having%20this%20issue%2C%20and%20it%20didn't%20fix%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEvery%20other%20Excel%20workbook%20she%20opens%2C%20changes%20the%20formula%20calculations%20to%20manual%20when%20it's%20supposed%20to%20be%20automatic.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20doesn't%20matter%20where%20the%20document%20resides%2C%20whether%20on%20her%20local%20workstation%2C%20SharePoint%2C%20or%20email%20and%20she%20has%20Windows%2010.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20contacted%20MS%20Support%20on%20this%20and%20he%20recommended%20I%20post%20in%20this%20forum.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20have%20any%20ideas%20on%20how%20to%20get%20formula%20calculations%20to%20ALWAYS%20be%20set%20to%20Automatic%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-278509%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-278593%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Calculations%20Reverting%20to%20Manual%20After%20I%20Change%20to%20Automatic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278593%22%20slang%3D%22en-US%22%3EHow%20to%20use%20spellnumber%20Help%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-278556%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Calculations%20Reverting%20to%20Manual%20After%20I%20Change%20to%20Automatic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278556%22%20slang%3D%22en-US%22%3E%3CP%3ESettings%20in%20File-%26gt%3BOptions%20and%20on%20ribbon%20are%20synced%2C%20that%20doesn't%20matter%20where%20to%20change.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOne%20of%20possible%20reasons%20if%20you%20have%20some%20workbook%20in%20Automatic%20opened%20and%20after%20that%20open%20another%20workbook%20with%20Manual%2C%20first%20workbook%20also%20will%20shift%20to%20Automatic.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnother%20reason%20could%20be%20in%20VBA%2C%20third-party%20add-ins%20or%20templates%20if%20you%20use%20them.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20something%20else%2C%20not%20sure%20right%20now.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-278531%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Calculations%20Reverting%20to%20Manual%20After%20I%20Change%20to%20Automatic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278531%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20setting%20in%20the%20Excel%20options%20is%20already%20set%20to%20Automatic.%20It's%20the%20workbook%20calculation%20that%20keeps%20changing%20intermittently.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%20if%20you%20change%20the%20workbook%20to%20Automatic%20from%20the%26nbsp%3BForumula's%20tab%2C%20save%20the%20document%2C%20then%20open%20it..%20it's%20still%20Automatic...%20but%20if%20you%20wait%20a%20while%2C%20then%20open%20the%20same%20workbook..%20it's%20reverted%20back%20to%20Manual%2C%20even%20when%20the%20option%20is%20set%20in%20the%26nbsp%3BExcel%20options%20itself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-278525%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Calculations%20Reverting%20to%20Manual%20After%20I%20Change%20to%20Automatic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-278525%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Catie%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDid%20I%20understand%20correctly%20with%20that%20setting%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20506px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F58348i8AAE39FEEA5649B3%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%3Eif%20you%20close%20and%20open%20workbook%20again%20the%20setting%20is%20shifted%20to%20Manual%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2508033%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Calculations%20Reverting%20to%20Manual%20After%20I%20Change%20to%20Automatic%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2508033%22%20slang%3D%22en-US%22%3ESame%20problem.%20It%20does%20have%20a%20connection%20to%20VBA.%20I%20have%20a%20workbook%20with%20a%20command%20button%20that%20imports%20and%20formats%20data%20using%20VBA%20instructions.%20Any%20time%20that%20button%20is%20clicked%2C%20and%20another%20workbook%20with%20auto%20calculate%20selected%20is%20open%2C%20the%20auto%20calculate%20workbook%20gets%20reverted%20to%20manual.%3C%2FLINGO-BODY%3E
New Contributor

I have a user who has the latest and greatest of Office 365 Office 2016, fresh install and completely updated, after she started having this issue, and it didn't fix it.

 

Every other Excel workbook she opens, changes the formula calculations to manual when it's supposed to be automatic.

 

It doesn't matter where the document resides, whether on her local workstation, SharePoint, or email and she has Windows 10.

 

I've contacted MS Support on this and he recommended I post in this forum.

 

Anyone have any ideas on how to get formula calculations to ALWAYS be set to Automatic?

5 Replies

Hi Catie,

 

Did I understand correctly with that setting

image.png

if you close and open workbook again the setting is shifted to Manual?

The setting in the Excel options is already set to Automatic. It's the workbook calculation that keeps changing intermittently.

 

Like if you change the workbook to Automatic from the Forumula's tab, save the document, then open it.. it's still Automatic... but if you wait a while, then open the same workbook.. it's reverted back to Manual, even when the option is set in the Excel options itself.

 

Settings in File->Options and on ribbon are synced, that doesn't matter where to change.

 

One of possible reasons if you have some workbook in Automatic opened and after that open another workbook with Manual, first workbook also will shift to Automatic.

 

Another reason could be in VBA, third-party add-ins or templates if you use them.

 

Perhaps something else, not sure right now.

Same problem. It does have a connection to VBA. I have a workbook with a command button that imports and formats data using VBA instructions. Any time that button is clicked, and another workbook with auto calculate selected is open, the auto calculate workbook gets reverted to manual.