| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping formula computations during entering data...
Hi!
We've got a sheet with lots of data and want to insert lots of formulas using VBScript. Now, every time we insert a formula the whole sheet gets recomputed and the thing runs three hours. Is there a way to make Excel stop calculating and turn it on later? Lots of Greetings! Volker |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Stopping formula computations during entering data...
ToolsOptionsCalculation, check Manual.
In VBA: Application.Calculation = xlManual -- Kind regards, Niek Otten "Volker Hetzer" wrote in message ... Hi! We've got a sheet with lots of data and want to insert lots of formulas using VBScript. Now, every time we insert a formula the whole sheet gets recomputed and the thing runs three hours. Is there a way to make Excel stop calculating and turn it on later? Lots of Greetings! Volker |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Stopping formula computations during entering data...
Hi Volker,
Try: Application.Calculation = xlCalculationManual 'Your code Application.Calculation = xlCalculationAutomatic --- Regards, Norman "Volker Hetzer" wrote in message ... Hi! We've got a sheet with lots of data and want to insert lots of formulas using VBScript. Now, every time we insert a formula the whole sheet gets recomputed and the thing runs three hours. Is there a way to make Excel stop calculating and turn it on later? Lots of Greetings! Volker |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Stopping formula computations during entering data...
Norman Jones wrote:
Hi Volker, Try: Application.Calculation = xlCalculationManual 'Your code Application.Calculation = xlCalculationAutomatic Thanks a lot, both of you! Volker |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| computations at odd locations | Excel Discussion (Misc queries) | |||
| Stopping IF command from entering zero or 1 for blank cells | Excel Worksheet Functions | |||
| Stopping a formula | Excel Discussion (Misc queries) | |||
| DATE COMPUTATIONS | Excel Worksheet Functions | |||
| manually entering data in a cell with formula w/o losing the formu | Excel Discussion (Misc queries) | |||
Linear Mode
