Calculation

[Farhad]

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,

 

[jlclyde]

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,

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

 

[Farhad]

this effects all workbooks thanks for your respond by the way