Application level calculation settings are just that, so changing the
setting may affect calculation in all workbooks in that Instance. Calling
Application.Calculate will do a full recalc of all open workbooks.
Worksheets also have individual an EnableCalculation property, maybe
disabling sheet calc's might serve your needs.

Not sure what you want to recalc, note you can also recalc individual sheets
or even a range (subject the sheet's EnableCalculation = true).

If you are changing application level settings normally you should reset it
to original state when done. Resetting calc to automatic will do a full
recalc of all open workbooks.

Regards,
Peter T


"snoopydoopy" wrote in message
...
Using C# and Office Interop, I am opening 2 different copies of a
workbook (I manually copy workbook1.xls to workbook2.xls).Both
workbook1 and workbook2 have exactly same copies of the macros. From
the interop, I am calling macros in workbook1 and workbook2. I am
able to do this successfully but I am worried about 1 thing. At
different points in the macro, I call application.calculate and then
reset it back to manual. My worry is that the calculation settings in
one workbook would affect the processing of the other workbook.
Anybody can throw light on this?