Excel 2007 formulas acting weird

[Guest]

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.

 

[Guest]

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

 

[Bernard Liengme]

Make sure you have Calculation Automatic on
Office button -> Excel Options ->Formulas Group ->Calculations Options
(first item) ->check the Automatic box
best wishes

 

[Mike Middleton]

MariaEll -

Maybe:

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

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

 

[Guest]

There is no Tools menu on Excel 2007.

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

 

[Guest]

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

 

[Guest]

That's ok

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

 

[Guest]

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