Automatic calculation

G

Guest

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.
 
N

Niek Otten

Check this list:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.
 

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

Manual Calculation in Excel 2007 with Calculate mode set to Automatic 1
Help!Excel will not calculate formulas- Not in manual calculation 6
Formulas do not update 2
automatic calculation 3
Linked values not updating 3
Formulas calculate the answer wrongly as 0 1
Workbook causes calculation errors 2
Cell =Now() << Can I get this to auto-update? 2

Top