Automatic and manual calculations
 

I have a large spreadsheet that has manual calculations. Part of the macro
opens up another smaller spreadsheet that I would like to have as automatic
calculations. When this opens I have some VB that sets this up to be
automatic, but this seems to set the big spreadsheet up to automatic as well,
resulting in a v long calculation.

Is there anyway just to have the small spreadsheet set up as automatic?

Thanks.