cary
Joined: 01 Jul 2006
Posts: 195
|
 Posted: 05/08/07 - 08:25 Post subject: |
 |
|
| Ahoy, people. I have a question. I always work in Excel on my job and till now I haven't had any problems. But recently it happens that its spread sheet does not update calculation. To be more precise, some of those calculations it updates, but some of them does not. What can I do to fix this? Are there any suggestions? |
|
bartholomeus
Joined: 14 Mar 2004
Posts: 206
|
| Posted: 06/27/07 - 00:44 Post subject: |
|
|
| Hi, there. You have an interesting problem. Have you seen in Tools/Calculation? Or if you put the cell and then click enter, but without changing the formula? But if nothing of this helps, I think I know what its all about. I think Excel is limited in how many calculations it will update automatically. When you reach this figure, then it stops. Then you need to do a full recalculation by clicking at the same time CTRL, SHIFT, F9. You can also save the document and it will recalculate completely. I hope this will help. Bye! |
|
