How to stop all Excel funtions for a period
 

Hello,
I built an Excal Worksheets that analyse specefic data that I Copy it
to a sheet called "Data"
when I clear the old data from the sheet, Excel starts to calculate all
the formulas in the workbook. then when I copy the new data, it starts
to calculate it again.
Is there a way to disable the functions, making my changes and then
enabling all the function again?

How to stop all Excel funtions for a period
 

Setting the calculation to manual at the start of the Macro might work.
Try this:

Application.Calculation = xlCalculationManual

How to stop all Excel funtions for a period
 

Nel post ups.com
*tonyhabayeb* ha scritto:

Hello,
I built an Excal Worksheets that analyse specefic data that I Copy it
to a sheet called "Data"
when I clear the old data from the sheet, Excel starts to calculate
all the formulas in the workbook. then when I copy the new data, it
starts to calculate it again.
Is there a way to disable the functions, making my changes and then
enabling all the function again?

Hi Tony,

Yes, you can stop Excel Calculation. Menu Tools, Options, Tab Calculation,
select Manual. At the end of your copy, set again on Automatic.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

How to stop all Excel funtions for a period
 

Hi Tony,

Expanding slightly on your other responses, try something like:

'=============
Public Sub Tester()
Dim CalcMode As Long

On Error GoTo XIT
With Application
CalcMode = .Calculation
.Calculation = xlCalculationManual
End With

'Your code

XIT:
Application.Calculation = CalcMode

End Sub
'<<=============


---
Regards,
Norman


"tonyhabayeb" wrote in message
ups.com...
Hello,
I built an Excal Worksheets that analyse specefic data that I Copy it
to a sheet called "Data"
when I clear the old data from the sheet, Excel starts to calculate all
the formulas in the workbook. then when I copy the new data, it starts
to calculate it again.
Is there a way to disable the functions, making my changes and then
enabling all the function again?

How to stop all Excel funtions for a period
 

Thnx a lot.

I used the following command to disable and enable it:

Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual

..... my code is here ....

Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic