All formulas display zero....HELP!!!

D

Drew Pruitt

Ok here is one for the ages. Every formula no matter what the data is
returns zero in the cell. If you use the formula editor to check the formula
it shows the correct result.

If I email the excel workbook to a peer they see the correct answer in the
cell. I have checked formula setting under tool-options, no luck or impact.

What gives???? Please advise what else or what setting could cause this to
happen.

Drew Pruitt
(e-mail address removed)
 
N

Neil_J

Have you made sure you've got Calculation set to Automatic?

Look in Tool-Options-Calculation. If it's set to manual, formulae will only
update when you press F9.
 

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

Excel insists on adding character to formula 5
GETPIVOTDATA returns zero when copied to another sheet 2
Sumif apllying to all sheets in workbook 2
Formula Help 5
Need formula to change cells from negative numbers to a zero. 2
Formula's 1
Vlookup array formula problem 2
Spurious Formula Omits Adjacent Cells 2

Top