cell values being computed

G

Guest

I am having trouble with the cell values being computed after they have been
typed in. If I am averaging a series of cells with a formula, that formula
will only compute after I have saved the document. So, to see the actual
value, I must constantly be saving my document.

I would also like to change the direction that my cells are grouped. Any
knowledge on this, too?
 
N

Niek Otten

Tools>Options>Calculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am having trouble with the cell values being computed after they have been
| typed in. If I am averaging a series of cells with a formula, that formula
| will only compute after I have saved the document. So, to see the actual
| value, I must constantly be saving my document.
|
| I would also like to change the direction that my cells are grouped. Any
| knowledge on this, too?
 
N

Niek Otten

No. Preferences>Calculation maybe?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Do you know what it is on a mac, too?
|
| "Niek Otten" wrote:
|
| > Tools>Options>Calculation tab, check Automatic
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > |I am having trouble with the cell values being computed after they have been
| > | typed in. If I am averaging a series of cells with a formula, that formula
| > | will only compute after I have saved the document. So, to see the actual
| > | value, I must constantly be saving my document.
| > |
| > | I would also like to change the direction that my cells are grouped. Any
| > | knowledge on this, too?
| >
| >
| >
 

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

EXCEL07 CELL FORMULAS WILL NOT COMPUTE TO A VALUE 2
SUM computed currency 3
Formulas displayed in cell rather than calculated values? 4
How do I ignore cell values of zero? 2
Why is the formula displaying rather than the actual value? 11
How to keep formula and be able to input value in cell? 0
Why won't target cell data changes trigger formula evaluation? 3
custom data validation on cells with data validation values 2

Top