| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Switch calculating cells off
I'm using a massive workbook. Everytime I do anything, the entire workbook
has to re-calculate every formula. This takes too long for me, to have to wait after every small amendment I make, or after every new cell is updated. Can I switch off the calculation whilst I make my changes and then swith it back on again, when I am ready? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Switch calculating cells off
You can go to Tools - Options - Calculation - Uncheck the the automatic
calculation or choose manual calculate. Then press F9 to make the whole book calculate. Or press Shift+F9 (i think) to only calculate the active sheet. "Al" wrote: I'm using a massive workbook. Everytime I do anything, the entire workbook has to re-calculate every formula. This takes too long for me, to have to wait after every small amendment I make, or after every new cell is updated. Can I switch off the calculation whilst I make my changes and then swith it back on again, when I am ready? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Switch calculating cells off
Marvellous...I thought there'd be something clever like that! Thank you!
"Harimau" wrote: You can go to Tools - Options - Calculation - Uncheck the the automatic calculation or choose manual calculate. Then press F9 to make the whole book calculate. Or press Shift+F9 (i think) to only calculate the active sheet. "Al" wrote: I'm using a massive workbook. Everytime I do anything, the entire workbook has to re-calculate every formula. This takes too long for me, to have to wait after every small amendment I make, or after every new cell is updated. Can I switch off the calculation whilst I make my changes and then swith it back on again, when I am ready? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells are not calculating on the fly | Excel Worksheet Functions | |||
| How to switch data between cells? | Excel Worksheet Functions | |||
| Is there a way to switch data between two cells? | Excel Discussion (Misc queries) | |||
| Calculating cells | Excel Discussion (Misc queries) | |||
| How do I switch arrow key commands for moving to other cells? | Excel Worksheet Functions | |||
Linear Mode
