Excel auto-mangling formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel's default "correction" of formulas is fraught with disaster. It seems
I can't attach an example spreadsheet, but try this:

In a new worksheet, enter into cell A11-
=sum(A1:a5)
In cell A12 enter =sum(a6:a10)

Now fill in numeric values for A1 to A10. You will notice that once you
reach A6, Excel starts CHANGING the formula in A11! If you don't notice this
misbehaviour, you end up with rubbish results.

Bad, Excel! BAD!

nylon.net

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...a9e5231&dg=microsoft.public.excel.crashesgpfs
 
Excel is not being bad. It is only following your instructions. If you do
not want it to "correct" formulae then:

Tools > Options... > Edit > and clear extend data range formats and formulas
 
Back
Top