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
I'm Ragavan Rajan - Lead Business Improvement, Innovation & Development, having professional experience in SharePoint 2010 / SharePoint 2013, Windows 7, Windows 8, One note, VB Script, Excel and VBA.
2 comments
Thanks a lot, it worked
Thanks. This really helped!