Forum Discussion
SOLVED - Drag to “fill” not working -- copies value and not formula - #2
I found this post title which describes the same issue: drag to “fill” not working – value is copied, formula ignored That solution is "missing a 'relative' reference". I don't think that's the pro...
Activate the Formulas tab of the ribbon.
Make sure that Calculation Options in the Calculation group is set to Automatic
Look at the status bar at the bottom of the workbook window.
Make sure that you do not see Circular References.
