SOLVED
Home

Fill handle and formula settings wrong?

Dragon_Claw
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!
Related Conversations
Teams Email Not Showing
A-A-Ron321 in Microsoft Teams on
3 Replies
Files in private channels for guest users
Hugo_CF79 in Microsoft Teams on
3 Replies
TEAMS notifications
KasiK2460 in Microsoft Teams on
0 Replies
Handling calls on main number
Chris_Moore in Microsoft Teams on
3 Replies
Allowing third party cookies in Desktop Teams App
NerdyBen in Microsoft Teams on
1 Replies