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?
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.