Forum Discussion

Copper Contributor

Jul 27, 2019

Solved

Formulas

I have been using Excel for many years but just in the last couple of days, something has happened to the Formula function in my spreadsheets. I set the formula to add boxes A1 through to say A20 in ...

Formulas and Functions

Haytham Amairah
Jul 27, 2019
Malleeboy

Hi,

You probably have the calculation option in the manual state!
Please make sure the calculation option is set to Automatic as follows:

Hope that helps

Haytham Amairah

Silver Contributor

Jul 27, 2019

Malleeboy

Hi,

You probably have the calculation option in the manual state!

Please make sure the calculation option is set to Automatic as follows:

Hope that helps

Malleeboy

Copper Contributor

Jul 27, 2019

You're right Haytham .... thankyou sincerely. I wonder who changed that? I certainly didn't! Gremlins!! Anyway, fixed now very speedily so your assistance is much appreciated. Thanks to the others as well for their advice.
Cheers,
Malleeboy

Haytham Amairah
Silver Contributor
Jul 27, 2019
Malleeboy

There are several reasons for this change!
It may be due to an add-in, a macro, or a bug in Excel.
Please check out this related https://exceloffthegrid.com/why-does-the-calculation-mode-keep-changing/.

Regards