Forum Discussion
Solved
Autofill in excel
Hi all, I have no problem using the autofill to fill values with equations in excel. However, there is a problem recently. Whenever I autofill these cells, they always appears same value as the ...
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.
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.