This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
My calculation option switches by its own to manual randomly. This causes dangerous results if a worker is going fast and takes for granted that excell is calculating when is not.
I found a thread like this since 2013 but without a clear answer. After10 years is there a solution? Or do I need to check every time and then go to the ribbon and change it manually each random time.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
The calculation settings are set by the first workbook that is opened in an Excel session (assuming nothing else changes them afterwards). So if the first workbook you open was saved with manual calculation, that is what your session is set to until you change it.
Sorry I can't because they are file from the company. But I checked if there was that line and I didn't find it.
The problem is not one file in particular it happens with files with and without macros.
I taught the problem was with macro files only but is not exclusively.
Could you share us your file? Then we may help you correct the macro。
Check if your macro has this line. You may remove it directly.
================================
Application.Calculation = xlManual
================================
Yes I bet is the macro, but I need to activate them to do the calcs, so disable them is not an option for me because I will just transfer my problem to something else and at the end would be the same. I would have to click each time to activate the macro to modify my file and is time wasted and will be the same time wasted to check if the calcul option is set to manual or automatic at every time I open the file.
One possible solution is to check if there are any add-ins or macros that may be causing the calculation option to switch to manual. You can try disabling any add-ins or macros and see if the issue persists.
Does issue happen on all the file or special file?