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.