Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Stop calculation on one specific sheets only
I ask this before, however the solution I received didn't work.
I have a big Workbook with many criteria using "SUMPRODUCT" formula . I need to remove the auto calculation on one of the sheet "Total" because each time I add something on the Data sheet, Excel recalculate and take more than 30 seconds. I need to keep the calculation on the Data sheet because I have some Vlookup formulas to get names when the user entered the ID numbers. I tried different VBA like ------------- Private Sub Worksheets_Calculate() Worksheets("Total").EnableCalculation =false End Sub Doesn't work at all. At each Data entries Excel recalculate Another one------------ Application.Calculation = xlCalculationManual ------ This one stop also my others worksheets to calculate and my others open Workbook. This is not what I need. If you have another option, please tell me. Thanks everyone. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
specific totals from sheets represented on other sheets | Excel Discussion (Misc queries) | |||
How to stop in the middle of re-calculation for all cells? | Excel Discussion (Misc queries) | |||
How to stop IRR calculation at a particular year... | Excel Discussion (Misc queries) | |||
Stop a calculation in progress | Excel Discussion (Misc queries) | |||
Stop an in-process subtotals calculation | Excel Worksheet Functions |