Copy Error- The formula copies into the new cell, but the new cell results mirror the original cell results

[Julianne West]

I am in Excel 2010. Usually, when I create a formula without any $ and CTRL+C or copy/drag it down, the results display as they should (examples are below), but yesterday, no matter how I copied the formula, the cell only showed the results from the formula in the original cell. I am assuming that I accidentally triggered a setting by typing too fast, but I have no idea what I did and it is impacting every spreadsheet even after rebooting the computer.

Example:
Row 1: =vlookup(d:d,p:m,2,0) - Results 5
Row 2: copy of =vlookup(d:d,p:m,2,0) - Results 5. If I retype the vlookup instead of copying it, the results are 7, which
is right.

Visual example:

A	B	C
20	20	40 is the result of formula =sum(A1:B2)
35	20	40 based on copying the formula above -- reads as =sum(A2:b2)
35	20	55 if I retype formula =sum(A3:b3)

<tbody>
</tbody>

 

[VoG]

Make sure that calculation is set to Automatic.

 

[Julianne West]

How do I do that? I can't find that in the Help option.

 

[Gigi_]

Tools-->Options-->Calculation

 

[Julianne West]

Thank you all! That was it. Shew.