Formula Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working in Excel 2002. If there is a formula already in place and I
change a number it will not recalculate; but if I redo the formula after
entering the number it will recalculate. Ex. AutoSum C1:C10 - if I put the
formula in with no numbers present it will NOT calculate when I enter the
numbers, however if I put the formula in AFTER the numbers are present it
will calculate. Also, cannot copy formulas, only gives me a "text" copy or
the actualy number. Does this sound like a corrupted file or is something
wrong in the main setup of Excel. If I copy from one file to another file it
again only brings over actual text/numbers; no formulas.
 
Look under Tools|Options; on the Calculation tab, click on
"Automatic."

Mark Lincoln
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Automatic Calculation" option intermittent 2
If formula-different numbers entries 2
Date calculations in Excel 2
formula to count text entries and return text with most entries 8
Cell display in 2007 1
Static date formula 3
Excel Sequential Numbering System 0
VBA Created Worksheet Function Not Recalculating 5

Back
Top