Excel 2003 formula issues

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

Guest

first problem; when I enter a formula in some columns the formual works, in
others the formula appears.
second problem; when I enter a formula and drag or copy it into other cells
in the same column I get the same result for all cells even though the result
should be different.
I've copy and pasted the spreadsheet to new sheets with the same result but
when I send the sheet to via email and it works on my home computer.
Any thoughts????????????
 
The columns where the formula appears rather than the result is most most
likely formatted as text. Change it to General or something more appropriate

Formulas appear to not update when your calculation method is set to Manual.
Go to Tools->Option->Calculation and set it to Automatic. It is a little
flakey in that opening a file saved with Manual calculation will cause all
open files to go to Manual, so be careful.
 
I thank you very much. I've been dealing with this for a week and it's
driving me nuts. Excel is a very powerful tool but at the same a little
quirky. Once again I thank you.
 

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

using the =page! feature to transpose a row to column 0
formulas copying from sheet to sheet 6
Copying formulas across columns 2
Formula results display only after pressing Enter key 1
Use & with two formulas 2
Copy corresponding cell in Column B if cell in A contains certain text? 1
Excel VBA 1
Excel formulas become cell contents 4

Back
Top