Automatic calculation
 

Hi,
When I change values that affect a formula it does not update.
I have checked Excel Options, Formulas, Workbook calculation, Automatic but
it seems to ignore this.
The only way I can update a value is to go to the formula cell and press
return.
The install was done from an Admin point on a server but I'm not sure if
that should make any difference.
Any suggestions gratefully recieved.

Automatic calculation
 

Check this list:

http://xldynamic.com/source/xld.xlFAQ0024.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"BeckyW" wrote in message ...
| Hi,
| When I change values that affect a formula it does not update.
| I have checked Excel Options, Formulas, Workbook calculation, Automatic but
| it seems to ignore this.
| The only way I can update a value is to go to the formula cell and press
| return.
| The install was done from an Admin point on a server but I'm not sure if
| that should make any difference.
| Any suggestions gratefully recieved.