Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculations on only a selection
How can I calculate a selection in a large worksheet. One of my worksheets
collects only the results of several other worksheets. This worksheet is 190MB and needs for a full calculation over 70 minites. Memory and processor have enough capacity and I am running Windows XP Pro with Office 2003. I wish to make a selction and calculate only this selection. Who has a solution? |
#2
|
|||
|
|||
Create a toolbar button and add this code
Private Sub RangeCalculate() Selection.Calculate End Sub selec t the cells, and click the button. -- HTH Bob Phillips "Knokie From Holland" <Knokie From wrote in message ... How can I calculate a selection in a large worksheet. One of my worksheets collects only the results of several other worksheets. This worksheet is 190MB and needs for a full calculation over 70 minites. Memory and processor have enough capacity and I am running Windows XP Pro with Office 2003. I wish to make a selction and calculate only this selection. Who has a solution? |
#3
|
|||
|
|||
You can calculate a single sheet using shift-F9.
To calculate the selected range you can download my RangeCalc addin from http://www.DecisionModels.com/downloads.htm You may want to look at some methods of speeding up your calculations: start at http://www.decisionModels.com/optspeedd.htm and associated pages. Charles ______________________ Decision Models FastExcel 2.1 now available www.DecisionModels.com "Knokie From Holland" <Knokie From wrote in message ... How can I calculate a selection in a large worksheet. One of my worksheets collects only the results of several other worksheets. This worksheet is 190MB and needs for a full calculation over 70 minites. Memory and processor have enough capacity and I am running Windows XP Pro with Office 2003. I wish to make a selction and calculate only this selection. Who has a solution? |
#4
|
|||
|
|||
Thanks Bob, it is running fast.
Knokie "Bob Phillips" wrote: Create a toolbar button and add this code Private Sub RangeCalculate() Selection.Calculate End Sub selec t the cells, and click the button. -- HTH Bob Phillips "Knokie From Holland" <Knokie From wrote in message ... How can I calculate a selection in a large worksheet. One of my worksheets collects only the results of several other worksheets. This worksheet is 190MB and needs for a full calculation over 70 minites. Memory and processor have enough capacity and I am running Windows XP Pro with Office 2003. I wish to make a selction and calculate only this selection. Who has a solution? |
#5
|
|||
|
|||
Excellent/ Always a good feeling :-)
Bob "Knokie From Holland" wrote in message ... Thanks Bob, it is running fast. Knokie "Bob Phillips" wrote: Create a toolbar button and add this code Private Sub RangeCalculate() Selection.Calculate End Sub selec t the cells, and click the button. -- HTH Bob Phillips "Knokie From Holland" <Knokie From wrote in message ... How can I calculate a selection in a large worksheet. One of my worksheets collects only the results of several other worksheets. This worksheet is 190MB and needs for a full calculation over 70 minites. Memory and processor have enough capacity and I am running Windows XP Pro with Office 2003. I wish to make a selction and calculate only this selection. Who has a solution? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculations crossing multiple sheets | Excel Discussion (Misc queries) | |||
Fit Selection Setting Doesn't Hold | Excel Discussion (Misc queries) | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
SELECTION() | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |