Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Weird Image problem | Excel Discussion (Misc queries) | |||
weird excel 2007 bug | Excel Discussion (Misc queries) | |||
EXCEL 2007 acting up | New Users to Excel | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
formulas are reading weird | Excel Worksheet Functions |