Excel changes my formulas

  • Thread starter Thread starter Eduardo Paris
  • Start date Start date
E

Eduardo Paris

Excel is changing my formulas every time I input a new
value that is an input for the formula.
I does not happen everywhere, but is fairly consistent
where it happens.
This is creating havoc in a monstrous edifice of numerical
information.
Let's say I have column A with an existing numerical
value, then I have column B with a formula adding columns
C and D (B=C+D). On columns C and D, I input numerical
values. Then I have column E, adding columns A+B (E=A+B).
In many places in my spreadsheet, the moment I put a
number, any munber, in column C or column D, column E
becomes A+B+C (E=A+B+C).
If I now go back to columns C or D and now type another
number on top of the previous one, the new formula for E
becomes E=A+B+C+D and so on.
 
Not sure if I fully understand that, but have you by any chance got 'Extend lists and
formulas' checked?

Tools / Options / Edit Tab / Extend List Formats and Formulas

Maybe that could be the cause??
 
Ken,

I just set up his sheet. I have the Extend lists and formulas checked.
When I put values in A C and D, it correctly copied the formulas in B
(=C6+D6) and E (+A6+B6) down. It didn't add the extra cells as Eduardo
says. I messed with it quite a bit. Dunno.

Eduardo, look carefully at the formulas above and ensure that something
didn't get changed earlier than you think.

Also, maybe you should unlock columns A, C, and D (Format - Cells -
Protection), and protect the sheet (Tools, Protection - Protect Sheet).
 
I was fishing - Hadn't come across the error, and that was all that I could think of as a
guess.
 
Back
Top