My question is if there is any way to setup excel to calculate one open file
manualy and other open files automaticaly. Please help me if anybody knows
about it.

Thanks,
--
Farhad Hodjat

On Sep 29, 12:13*pm, Farhad wrote:
My question is if there is any way to setup excel to calculate one open file
manualy and other open files automaticaly. Please help me if anybody knows
about it.

Thanks,
--
Farhad Hodjat

why not use an Application.Calculation = xlCalculationManual in an
Open event for this workbook?
To do this click Alt + F11. Go to the workbook that you want to add
this to on the xl icon where it says This Workbook double click.
Change the pull downs at the top to be workbooks and Open. then put
in this code.

Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub

Now when this workbook is opened it shuts off the calculation. you
can add anouther event to turn it back on.
Thanks,
Jay

this effects all workbooks thanks for your respond by the way
--
Farhad Hodjat


"jlclyde" wrote:

On Sep 29, 12:13 pm, Farhad wrote:
My question is if there is any way to setup excel to calculate one open file
manualy and other open files automaticaly. Please help me if anybody knows
about it.

Thanks,
--
Farhad Hodjat

why not use an Application.Calculation = xlCalculationManual in an
Open event for this workbook?
To do this click Alt + F11. Go to the workbook that you want to add
this to on the xl icon where it says This Workbook double click.
Change the pull downs at the top to be workbooks and Open. then put
in this code.

Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub

Now when this workbook is opened it shuts off the calculation. you
can add anouther event to turn it back on.
Thanks,
Jay