Formulas mode needs to changed back auto everytime

[bhavdip_mangukiya]

Hello Friends,

I have a excel file with macro. i have put some formulas in sheet as well. but, every time i opened the file i have to change formula mode to automatic from manual for calculation

is there a way i can set it to automatic permanently

 

[rollis13]

You probably have a macro that sets Manual Calculation and you forgot to restore Automatic Calculation before the exiting the macro.

 

[Ottsel]

Change your settings here:

 

[bhavdip_mangukiya]

Change your settings here:

View attachment 84482

this is the issue, i have to go there everytime to change it when i reopens the file

 

[rollis13]

@bhavdip_mangukiya, since you didn't consider my post #2, do you mind showing your macros ?

 

[bhavdip_mangukiya]

@bhavdip_mangukiya, since you didn't consider my post #2, do you mind showing your macohh

oh i see!! thank you, when i look into my macro. i saw it there was a line which was causing it

thank you

 

[rollis13]

Thanks for the positive feedback, glad we were able to help.

 

[Fluff]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.