Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
workbook calculations
I have a bunch of calculations in my workbook and every time i make a change
to a static number that has nothing to do with the calculations the whole workbook has to recalculate. Is their a way to not have my workbook recalculate when I change these static cells? I can not turn off autocalc as a solution either. thanks, Jase |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
workbook calculations
Go to tools | options | calculations tab | check manual option | ok
On Sep 22, 2:00*pm, Jase wrote: I have a bunch of calculations in my workbook and every time i make a change to a static number that has nothing to do with the calculations the whole workbook has to recalculate. Is their a way to not have my workbook recalculate when I change these static cells? I can not turn off autocalc as a solution either. thanks, Jase |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
workbook calculations
I can not turn off autocalc as a solution either
"muddan madhu" wrote: Go to tools | options | calculations tab | check manual option | ok On Sep 22, 2:00 pm, Jase wrote: I have a bunch of calculations in my workbook and every time i make a change to a static number that has nothing to do with the calculations the whole workbook has to recalculate. Is their a way to not have my workbook recalculate when I change these static cells? I can not turn off autocalc as a solution either. thanks, Jase |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
workbook calculations
You can mess with VB, make it so the cells are on a manual calculation but
automatically update only when certain criteria exist. Not sure if you want to go to those lengths though. the other answer is there is nothing you can do. The cells automatically update every time you change a value in your workbook. "Jase" wrote: I have a bunch of calculations in my workbook and every time i make a change to a static number that has nothing to do with the calculations the whole workbook has to recalculate. Is their a way to not have my workbook recalculate when I change these static cells? I can not turn off autocalc as a solution either. thanks, Jase |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook Calculations set to Automatic - Excel 2007 | Excel Worksheet Functions | |||
maximum calculations per excel workbook? | Excel Discussion (Misc queries) | |||
Speeding up workbook calculations | Excel Discussion (Misc queries) | |||
workbook size and calculations | Excel Worksheet Functions | |||
automatic calculations within workbook | Setting up and Configuration of Excel |