Rather than setting application.calculation to xlAutomatic (or using
application.calculate), you might just use ActiveSheet.Calculate as necessary
w/in the smaller spreadsheet.

"Muttley" wrote:

> 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.