Formulas Stopped Working

G

Guest

I've been working on a new spreadsheet for several weeks. All of the
formulas stopped working in it today. I opened some other Excel files and
they stopped working as well.

If I change a value in a cell that the formula cell should calculate, it
doesn't change. HOWEVER, if I double click on the formula cell, then enter,
it calculates.

Any clue as to what's happening?
 
R

RagDyeR

Set the calc "switch" to Auto!

<Tools> <Options <Calculation> tab.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I've been working on a new spreadsheet for several weeks. All of the
formulas stopped working in it today. I opened some other Excel files and
they stopped working as well.

If I change a value in a cell that the formula cell should calculate, it
doesn't change. HOWEVER, if I double click on the formula cell, then enter,
it calculates.

Any clue as to what's happening?
 

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

Formula stopped working 3
Calculating cells 1
Excel 07 formulas on a whole spread sheet stopped working 2
Fill down formulas in existing excel docs stopped working 1
No formulas Work 3
Formula problems 2
formulas won't fill by dragging 4
URGENT - Formulas stopped working 6

Top