Formulas Not working when dragging down

Excel Issues/ Problem #1:

Issue:

Formulas Not working when I drag it down:

when I drag a formula from the cell on downwards, the numbers remain the same in all the pasted cells. When I double click on the individual formulas, it updates.

Solution:

Go to Formulas Menu -> calculation- change it to Automatic

Alternatively you can watch my below video for better clarity

if the video is not visible please click here

Note:

If you use Name ranges for cell and try to drag it down . It wont work. You should use cell Reference

Please leave your comments below if this tip is useful