Forum Discussion
Re: Autofill in excel
Make sure that Calculation Options on the Formulas tab of the ribbon is set to Automatic.
3 Replies
HansVogelaar Thanks a lot. I have changed the formula to automatic.
However, as I mentioned, I did not have this problem before. It was automatic by default setting and I have not ever changed it at all. I do not know why this setting changed to manual recently?
The Calculation Options setting is saved with the workbook.
If you happen to open a workbook in which Calculation Options was set to Manual when it was last saved, Excel will leave Calculation Options set to Manual until the end of the session unless you explicitly set it to Automatic again.
Most common reason if you open any workbook was set to manual mode (not necessary your workbook, any other one), each next opened workbook automatically will be shifted on manual mode.
