the setting in Tools==Options==Calculation (Automatic or Manual) , can
it be applied to a single worksheet within a workbook or at least single
workbook? I want to have calculation be automatic in all worksheets except
one, where I want it set to manual. Can this be done? How?

I don't want to reset Tools==Options==Calculation (Manual) each time I
open the Manual Calc workbook. I'd like Calc to be defaulted to Automatic,
and when I open the one manual WB, calc is at once set to manual only for
that WB.

If this needs VBA, it will be much appreciated if you specify the exact
wording for me to cut and paste since I'm not a VBA expert.

It's ok, although not the preferred way, if the VBA makes the calc manual
without my having to reset Tools==Options==Calculation (Manual) each time ,
but also manual for all workbooks opened after the VBA-manual calc workbook
is opened, since presumably I can re-start a separate instance of Excel
containing only this VBA-manual calc workbook, and open all my other WB in
the first instance of Excel where the program was re-loaded separately. Will
this work, ie, Manual calculation automatically selected by your VBA will
apply only to open workbooks in one instance of Excel, while not affecting
automatic calc workbooks opened in another instance of Excel started in
parallel on the same machine?

Separate question. When I open several windows of Excel workbooks, they
cannot be moved so one workbook is on one monitor and another workbook is on
my second dualview monitor. They can only be viewed on the same monitor as
each other open workbook. The only way I can split a workbook to the other
screen, while another workbook is on the main screen, is to open another
instance of Excel for that workbook and it can then be split. Is there a way
to split workbooks opened in the same instance of Excel to 2 monitors without
having to open another instance of Excel?

Thanks for your help.