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?

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

Application.Calculation = xlCalculationManual

Nel post news:1151663214.512698.49750@p79g2000cwp.googlegroups.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

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" <tonyhabayeb@gmail.com> wrote in message
news:1151663214.512698.49750@p79g2000cwp.googlegroups.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?
>

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