cells won't calculate

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Hi. I am stumped. Wether I put in formula's or numbers
in a cell they are ignored by formulas that calculate
depending on them?

They aren't protected, I tried clearing them, then
deleting the whole section and starting over.

If I copy a formula into the cells from other cells that
work. Even though the formulas adjusted the ranges the
formula result is from the origonal cell.


?????
TIA

Todd
 
Okay, and don't take this the wrong way but, is your
default calculation method set to MANUAL under the
TOOLS/OPTION settings? If your on automatic, check the
format of the cell and make sure its not set to TEXT. If
that isn't it, run the TOOLS/FORMULA AUDITING and trace
the dependents on the formula that should be calling the
cell you can't get to work. Just some suggestions.
 

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

Back
Top