SOLVED

Fill handle and formula settings wrong?

%3CLINGO-SUB%20id%3D%22lingo-sub-338484%22%20slang%3D%22en-US%22%3EFill%20handle%20and%20formula%20settings%20wrong%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-338484%22%20slang%3D%22en-US%22%3ELately%2C%20my%20fill%20handle%20has%20gone%20off%20the%20rails.%20I%20used%20to%20double%20click%20on%20the%20little%20arrow%20and%20the%20rest%20of%20the%20column%20would%20get%20the%20formula.%3CBR%20%2F%3E%3CBR%20%2F%3ENow%20it%20just%20copies%20the%20data(using%20the%20same%20formula).%20I%20don't%20keep%20absolute%20refrences%2C%20but%20the%20data%20is%20%22copied%22%2C%20even%20though%20the%20formula%20and%20refrences%20are%20different.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20I%20paste%20with%20formatting%20only%2C%20it%20will%20erase%20the%20cell%20with%20the%20data%20that%20was%20just%20%22copied%22.%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20used%20to%20work%20just%20fine%2C%20what's%20going%20on%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-338484%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-338768%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20handle%20and%20formula%20settings%20wrong%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-338768%22%20slang%3D%22en-US%22%3EYes%2C%20this%20is%20it!%20Thanks%20so%20much!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-338564%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20handle%20and%20formula%20settings%20wrong%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-338564%22%20slang%3D%22en-US%22%3E%3CP%3ECheck%20on%20ribbon%20if%20Formulas-%26gt%3BCalculation%20Options%20is%20set%20to%20Automatic%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-338487%22%20slang%3D%22en-US%22%3ERe%3A%20Fill%20handle%20and%20formula%20settings%20wrong%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-338487%22%20slang%3D%22en-US%22%3EAlso%2C%20with%20the%20%22copied%22%20formula%20(referencing%20different%20cells%20for%20data)%2C%20if%20I%20go%20down%20the%20column%20or%20row%2C%20open%20the%20formula%2C%20and%20push%20enter%2C%20it%20will%20now%20display%20the%20proper%20information.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor
Lately, my fill handle has gone off the rails. I used to double click on the little arrow and the rest of the column would get the formula.

Now it just copies the data(using the same formula). I don't keep absolute refrences, but the data is "copied", even though the formula and refrences are different.

If I paste with formatting only, it will erase the cell with the data that was just "copied".

It used to work just fine, what's going on?
3 Replies
Highlighted
Also, with the "copied" formula (referencing different cells for data), if I go down the column or row, open the formula, and push enter, it will now display the proper information.
Highlighted
Solution

Check on ribbon if Formulas->Calculation Options is set to Automatic

Highlighted
Yes, this is it! Thanks so much!