Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel calculates after each cell entry
How can I stop excel calculating after each entry i enter into a cell.
The calculation can take up to 15 seconds to calculate I can Tab to the next cell when entering text but it starts to calculate and when I enter figures then I cannot move to next row till the calculation has finished. The last line on the screen just above Start button changes from Ready to show Calculating Cells: 15% then changes back to Ready after it goes through to approx 75% I have checked ToolOptionsCalculation and I have Calculation on Automatic and Work sheet Options has a tick in Update remote references and save external link values. This is the first time this has happened. I have excel 2000. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel calculates after each cell entry
Set ToolsOptionsCalculation to Manual and recalc with F9
-- Kind regards, Niek Otten Microsoft MVP - Excel "bee" wrote in message ... | How can I stop excel calculating after each entry i enter into a cell. | The calculation can take up to 15 seconds to calculate I can Tab to the next | cell when entering text but it starts to calculate and when I enter figures | then I cannot move to next row till the calculation has finished. | The last line on the screen just above Start button changes from Ready to | show Calculating Cells: 15% then changes back to Ready after it goes through | to approx 75% | I have checked ToolOptionsCalculation and I have Calculation on Automatic | and Work sheet Options has a tick in Update remote references and save | external link values. | This is the first time this has happened. | I have excel 2000. | Thank you | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel calculates after each cell entry
Tools|options|calculation and select manual
F9 to perform manual calculation Mike "bee" wrote: How can I stop excel calculating after each entry i enter into a cell. The calculation can take up to 15 seconds to calculate I can Tab to the next cell when entering text but it starts to calculate and when I enter figures then I cannot move to next row till the calculation has finished. The last line on the screen just above Start button changes from Ready to show Calculating Cells: 15% then changes back to Ready after it goes through to approx 75% I have checked ToolOptionsCalculation and I have Calculation on Automatic and Work sheet Options has a tick in Update remote references and save external link values. This is the first time this has happened. I have excel 2000. Thank you |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel calculates after each cell entry
Thank you for your advice
I have selected Manual and have entered tick into Recalculate before save and clicked OK. I have then entered some data and then pressed F9 but it does not calculate. I have then clicked on Calc Now (F9) and it calculates but it is also slow. How do I get it to work on F9. Thank you "Mike H" wrote: Tools|options|calculation and select manual F9 to perform manual calculation Mike "bee" wrote: How can I stop excel calculating after each entry i enter into a cell. The calculation can take up to 15 seconds to calculate I can Tab to the next cell when entering text but it starts to calculate and when I enter figures then I cannot move to next row till the calculation has finished. The last line on the screen just above Start button changes from Ready to show Calculating Cells: 15% then changes back to Ready after it goes through to approx 75% I have checked ToolOptionsCalculation and I have Calculation on Automatic and Work sheet Options has a tick in Update remote references and save external link values. This is the first time this has happened. I have excel 2000. Thank you |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel calculates after each cell entry
Thank you
Are you saying that I have to go to ToolsOptionsand click on Calc Now (F9) each time I want to calculate as when I select Manual and click OK then Calculate comes up on last line but the calculation does not take place until I go back and select CALC NOW (F9) "Niek Otten" wrote: Set ToolsOptionsCalculation to Manual and recalc with F9 -- Kind regards, Niek Otten Microsoft MVP - Excel "bee" wrote in message ... | How can I stop excel calculating after each entry i enter into a cell. | The calculation can take up to 15 seconds to calculate I can Tab to the next | cell when entering text but it starts to calculate and when I enter figures | then I cannot move to next row till the calculation has finished. | The last line on the screen just above Start button changes from Ready to | show Calculating Cells: 15% then changes back to Ready after it goes through | to approx 75% | I have checked ToolOptionsCalculation and I have Calculation on Automatic | and Work sheet Options has a tick in Update remote references and save | external link values. | This is the first time this has happened. | I have excel 2000. | Thank you | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When Excel incorrectly Calculates | Excel Discussion (Misc queries) | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
excel template automatic calculates | Excel Discussion (Misc queries) | |||
Creating a formula that calculates a total cell | Excel Discussion (Misc queries) | |||
Excel xp giving me CAN when I want CNA entry in a cell. | Excel Discussion (Misc queries) |