Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet calculation
Hi,
I have a huge Workbook with many sheets doing different reports using Sumproduct, Match, array, Etc. The problem is when we try to enter new data, the Workbook recal on each entries and take a lot of time. On the "data sheet" I need to keep the cal because I have a match to retrieve the name of the user using his salesman number. I have also an array in each row. I tried adding on the "Reports sheet" the code below, however the worksheet still do the calculation. Can you help Thanks This is the code I use in the Code Report sheet. Private Sub Worksheet_Calculation() Worksheets.EnableCalculation = False End Sub Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sheet calculation
Forget about this post I create another one by mistake.
"Mouimet" wrote: Hi, I have a huge Workbook with many sheets doing different reports using Sumproduct, Match, array, Etc. The problem is when we try to enter new data, the Workbook recal on each entries and take a lot of time. On the "data sheet" I need to keep the cal because I have a match to retrieve the name of the user using his salesman number. I have also an array in each row. I tried adding on the "Reports sheet" the code below, however the worksheet still do the calculation. Can you help Thanks This is the code I use in the Code Report sheet. Private Sub Worksheet_Calculation() Worksheets.EnableCalculation = False End Sub Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stop calculation on a sheet | Excel Programming | |||
Rate sheet re-calculation | Excel Discussion (Misc queries) | |||
Calculation Satus for a Sheet | Excel Programming | |||
time sheet calculation | Excel Discussion (Misc queries) | |||
automated calculation except on one sheet | Excel Programming |