Formulas

[OldHen999]

I'm working on a 2006 audit report with formulas already entered...They are
correct...I'm saving as a new 2007 report and changing the numbers...The
formula brought forward won't calculate any of my new numbers...It lets me
add the numbers in, but it won't automatically formulate them...So I went
back to the 2006 report and tried putting new numbers in there...It won't
recalculate either...What has this person done to the worksheet???They are no
longer working and noone in the Office can figure this one out....I really
don't want to delete a 62 page report and start over...Any ideas on what this
person has done with the old worksheet and formulas and how I can get the new
report to take my numbers???

 

[JE McGimpsey]

I'm working on a 2006 audit report with formulas already entered...They are
correct...I'm saving as a new 2007 report and changing the numbers...The
formula brought forward won't calculate any of my new numbers...It lets me
add the numbers in, but it won't automatically formulate them...So I went
back to the 2006 report and tried putting new numbers in there...It won't
recalculate either...What has this person done to the worksheet???They are no
longer working and noone in the Office can figure this one out....I really
don't want to delete a 62 page report and start over...Any ideas on what this
person has done with the old worksheet and formulas and how I can get the new
report to take my numbers???

There are a number of things that could cause this, but you haven't give
us very much information to help narrow down the problem.

Perhaps if you

- gave examples of the formulae that you're trying to change
- tell us how you're trying to change the formula(e)
- tell us the expected result for the change
- explain what you mean by "won't automatically formulate them"

someone might be able to take a stab.

For the recalculation part of the problem, if you've got calculation set
to Automatic (in Preferences/Calculation), then check that the cell is
formatted as General or a number/date format. If the cells are formatted
as Text, then XL's input parser will interpret the result of your change
as Text, and will display the formula, rather than calculating.

 

[OldHen999]

There are a number of things that could cause this, but you haven't give
us very much information to help narrow down the problem.

Perhaps if you

- gave examples of the formulae that you're trying to change
- tell us how you're trying to change the formula(e)
- tell us the expected result for the change
- explain what you mean by "won't automatically formulate them"

someone might be able to take a stab.

For the recalculation part of the problem, if you've got calculation set
to Automatic (in Preferences/Calculation), then check that the cell is
formatted as General or a number/date format. If the cells are formatted
as Text, then XL's input parser will interpret the result of your change
as Text, and will display the formula, rather than calculating.

JE McGimpsey:

Here are some rough examples...I'm a beginner at all of this so have
patience

It's a school district report and audit.

Headings go something like: Total
(Formula)

Expense Program Revenue Budget Over/Under

1111 2222 3333 4444
1111 2222 3333 4444

Total
Formulas all across bottom of each columns also....


After I bring it forward and (save as) to a new report...I go in and delete
just the data, and it leaves just the formulas, which show like a dash in
the cell.....When I start adding in new data it automatically starts adding
or subtracting and fills in the formula columns and row totals...This
worksheet is letting me add new data, but the formula totals aren't changing
at all...Does this help any???

 

[JE McGimpsey]

Here are some rough examples...I'm a beginner at all of this so have
patience

It's a school district report and audit.

Headings go something like: Total
(Formula)

Expense Program Revenue Budget Over/Under

1111 2222 3333 4444
1111 2222 3333 4444

Total
Formulas all across bottom of each columns also....


After I bring it forward and (save as) to a new report...I go in and delete
just the data, and it leaves just the formulas, which show like a dash in
the cell.....When I start adding in new data it automatically starts adding
or subtracting and fills in the formula columns and row totals...This
worksheet is letting me add new data, but the formula totals aren't changing
at all...Does this help any???

Hmm...

If "it" really "automatically starts adding or subtracting", I'm not
sure what's going on. If that's what's *supposed* to happen, and it's
not happening, then I wonder if your cells are formatted as Text, in
which case the SUM() function (you didn't say what formulae you were
using!) will ignore it.

Try copying an empty cell, then select your data cells. Choose
Edit/Paste Special, selecting the Values and Add radio buttons. Click
OK. That should convert any Text values to numbers. Make sure you've got
the cells formatted the way you want them as a number.