Formulas Not Calculating Correctly in Excel 2003

[DieHard49]

I'm losing my mind! I have been using Excel for over 10 years and I have NEVER seen anything like this! For some reason, formulas are not calculating correctly in Excel. Here's an example:

A B C D
1 2 3 6
26 5 6 6
1 7 9 6


1.) I used a simple formula for this table. I clicked on cell D1 and entered =A1 + B1 + C1
2.) The answer that Excel returned was "6", which is the correct answer
3.) I then dragged the formula down to the rest of the cells in column D
4.) As you can see, column D has the same answer for ALL of the row calculations
5.) I checked the formula for EACH cell in column D
6.) The formula is correct, meaning I didn't just copy the number 6.
7.) The formula for row 2 reads as follows (= A2+ B2 + C2) AND THE ANSWER EXCEL IS GIVING ME IS STILL 6!


Has anyone seen anything like this before? I started off by working on VLOOKUPS and was pulling my hair out because I couldn't figure out where my formulas were off. It then occured to me to check to see if it was an issue with Excel. I opened several different work sheets to make sure it wasn't just a problem with that worksheet. PLEASE HELP!

[jeffreybrown]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[DieHard49]

I closed Excel completely and opened a new blank spreadsheet. The formula issues seems to have resolved itself. I will attempt to do the VLOOKUP formulas again, but I am beside myself because of the time I wasted thinking my formulas were wrong!

[DieHard49]

My apologies. Fixed.

[DieHard49]

Turns out the formula calculation was set to manual. When that is the case, the screen needs to be refreshed in order for the calculations to display correctly.

[FDibbins]

without being able to replicate your problem, its hard to say what could be causing it. i tried in 2007 and got

6
37
17

edit: aahh the old "F9 to calc" problem. i should have thought of that. glad you got it fixed though