Excel 2007 formulas acting weird
 

I opened my Excel just now to my monthly budget (from the template that I
downloaded). And I added a dollar amount to the spreadsheet, but for some
reason, it didn't take. So I experimented, I opened another template, and did
the same thing, still nothing, BUT, when I saved it, only THEN did it the
formula work. I hope someone can understand what I'm saying. In other words,
the formulas aren't working when they're supposed to. When I add or take away
a number, since it's a template and the formulas are already there, it's
supposed to act accordingly, but it's not. Please help.

Excel 2007 formulas acting weird
 

do you have the spreadsheet set to 'autocalculate'?
Tools....options.....calculation and autocalcuatlion checked off?

"MariaEll" wrote:

I opened my Excel just now to my monthly budget (from the template that I
downloaded). And I added a dollar amount to the spreadsheet, but for some
reason, it didn't take. So I experimented, I opened another template, and did
the same thing, still nothing, BUT, when I saved it, only THEN did it the
formula work. I hope someone can understand what I'm saying. In other words,
the formulas aren't working when they're supposed to. When I add or take away
a number, since it's a template and the formulas are already there, it's
supposed to act accordingly, but it's not. Please help.

Excel 2007 formulas acting weird
 

Make sure you have Calculation Automatic on
Office button - Excel Options -Formulas Group -Calculations Options
(first item) -check the Automatic box
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"MariaEll" wrote in message
...
I opened my Excel just now to my monthly budget (from the template that I
downloaded). And I added a dollar amount to the spreadsheet, but for some
reason, it didn't take. So I experimented, I opened another template, and
did
the same thing, still nothing, BUT, when I saved it, only THEN did it the
formula work. I hope someone can understand what I'm saying. In other
words,
the formulas aren't working when they're supposed to. When I add or take
away
a number, since it's a template and the formulas are already there, it's
supposed to act accordingly, but it's not. Please help.

Excel 2007 formulas acting weird
 

MariaEll -

Maybe:

Office Button (top left corner) | Excel Options | Formulas | Automatic

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"MariaEll" wrote in message
...
I opened my Excel just now to my monthly budget (from the template that I
downloaded). And I added a dollar amount to the spreadsheet, but for some
reason, it didn't take. So I experimented, I opened another template, and
did
the same thing, still nothing, BUT, when I saved it, only THEN did it the
formula work. I hope someone can understand what I'm saying. In other
words,
the formulas aren't working when they're supposed to. When I add or take
away
a number, since it's a template and the formulas are already there, it's
supposed to act accordingly, but it's not. Please help.

Excel 2007 formulas acting weird
 

There is no Tools menu on Excel 2007.


"tim m" wrote:

do you have the spreadsheet set to 'autocalculate'?
Tools....options.....calculation and autocalcuatlion checked off?

"MariaEll" wrote:

I opened my Excel just now to my monthly budget (from the template that I
downloaded). And I added a dollar amount to the spreadsheet, but for some
reason, it didn't take. So I experimented, I opened another template, and did
the same thing, still nothing, BUT, when I saved it, only THEN did it the
formula work. I hope someone can understand what I'm saying. In other words,
the formulas aren't working when they're supposed to. When I add or take away
a number, since it's a template and the formulas are already there, it's
supposed to act accordingly, but it's not. Please help.

Excel 2007 formulas acting weird
 

:O) That's what i get for trying to answer when I don't have 2007.

"MariaEll" wrote:

There is no Tools menu on Excel 2007.


"tim m" wrote:

do you have the spreadsheet set to 'autocalculate'?
Tools....options.....calculation and autocalcuatlion checked off?

"MariaEll" wrote:

I opened my Excel just now to my monthly budget (from the template that I
downloaded). And I added a dollar amount to the spreadsheet, but for some
reason, it didn't take. So I experimented, I opened another template, and did
the same thing, still nothing, BUT, when I saved it, only THEN did it the
formula work. I hope someone can understand what I'm saying. In other words,
the formulas aren't working when they're supposed to. When I add or take away
a number, since it's a template and the formulas are already there, it's
supposed to act accordingly, but it's not. Please help.

Excel 2007 formulas acting weird
 

That's ok :)

"tim m" wrote:

:O) That's what i get for trying to answer when I don't have 2007.

"MariaEll" wrote:

There is no Tools menu on Excel 2007.


"tim m" wrote:

do you have the spreadsheet set to 'autocalculate'?
Tools....options.....calculation and autocalcuatlion checked off?

"MariaEll" wrote:

I opened my Excel just now to my monthly budget (from the template that I
downloaded). And I added a dollar amount to the spreadsheet, but for some
reason, it didn't take. So I experimented, I opened another template, and did
the same thing, still nothing, BUT, when I saved it, only THEN did it the
formula work. I hope someone can understand what I'm saying. In other words,
the formulas aren't working when they're supposed to. When I add or take away
a number, since it's a template and the formulas are already there, it's
supposed to act accordingly, but it's not. Please help.

Excel 2007 formulas acting weird
 

Mike and Bernard, thank you both, that solved my problem.



"Mike Middleton" wrote:

MariaEll -

Maybe:

Office Button (top left corner) | Excel Options | Formulas | Automatic

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"MariaEll" wrote in message
...
I opened my Excel just now to my monthly budget (from the template that I
downloaded). And I added a dollar amount to the spreadsheet, but for some
reason, it didn't take. So I experimented, I opened another template, and
did
the same thing, still nothing, BUT, when I saved it, only THEN did it the
formula work. I hope someone can understand what I'm saying. In other
words,
the formulas aren't working when they're supposed to. When I add or take
away
a number, since it's a template and the formulas are already there, it's
supposed to act accordingly, but it's not. Please help.