I just tried that, Dave, and you're right. I had one workbook with
formulas and conditional formatting in one monitor, and opened a new
instance of Excel with a new workbook in the other monitor. I copied
a range form the first book and tried Paste Special in the second
book. It gave me a list of options like Workbook Object, Enhanced
Metafile, Bitmap, etc. rather than the list of Values, Formulas,
Formatting, Column Width, etc that I expected.
So I presume that I will need to generally stick with stretching the
one instance over two monitors, and might occasionally be able to use
the two instances (only because it's less of a pain to set up).
Thanks for your help.