The calculation settings are per session, not per workbook, you wuld need
to open two sessions to have one be automatic and the other manual. You
would not then becable to copy and paste equartions between them.

"Rich D" wrote:

I have 2 totally separate Excel workbooks open in my toolbar. when I tell it
to calculate 1 of the workbooks manually, it also sets the other workbook to
calculate manually...even though the other workbook doesn't even have
calculations in it. should this be happening? How can I make the manual
calculations apply only to the 1 workbook? Thanks for your help.
--
Rich D
Armstrong Custom Homes
Redmond