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 problem here.

I have an exported bookkeeping account worksheet with three columns: Debit, Credit, Balance. I’m looking for missing transactions and short payments. All of the cells currently are values, and this is the only formula.

First, I’m inserting a blank line, and adding an adjusting calculation (A).

Then I update the Balance column with a simple formula (B) to create a running balance with DR – CR.–bog simple.

For a reason I can’t understand, when I drag the corner handle down to lower cells (C), Excel correctly copies the cell formula with incrementing references (D), but it flags an error and displays the same value.

Did I accidentally click a Bizzaro-World keyboard shortcut? What is going on here and how do I fix it?

​I found this post title which describes the same issue:drag to “fill” not working – value is copied, formula ignoredThat solution is “missing a ‘relative’ reference”. I don’t think that’s the problem here. I have an exported bookkeeping account worksheet with three columns: Debit, Credit, Balance. I’m looking for missing transactions and short payments. All of the cells currently are values, and this is the only formula. First, I’m inserting a blank line, and adding an adjusting calculation (A).Then I update the Balance column with a simple formula (B) to create a running balance with DR – CR.–bog simple. For a reason I can’t understand, when I drag the corner handle down to lower cells (C), Excel correctly copies the cell formula with incrementing references (D), but it flags an error and displays the same value. Did I accidentally click a Bizzaro-World keyboard shortcut? What is going on here and how do I fix it?     Read More

​