cell values being computed
 

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?

cell values being computed
 

ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Matthew Bradford" <Matthew wrote in message
...
|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?

cell values being computed
 

Do you know what it is on a mac, too?

"Niek Otten" wrote:

ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Matthew Bradford" <Matthew wrote in message
...
|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?

cell values being computed
 

I figured it out. Thank you so much, Niek.

"Niek Otten" wrote:

ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Matthew Bradford" <Matthew wrote in message
...
|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?

cell values being computed
 

No. PreferencesCalculation maybe?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Matthew Bradford" wrote in message
...
| Do you know what it is on a mac, too?
|
| "Niek Otten" wrote:
|
| ToolsOptionsCalculation tab, check Automatic
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Matthew Bradford" <Matthew wrote in message
| ...
| |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?
|
|
|