I have two different workbooks I would like to view at the same time. I would
also like to copy & paste cels from one spreadsheet to the other.

Under Winxp and earlier I could have two instances of Excel open at the same
time. Win-7 seems to prevent this.

The answers previously given do not apply to Win-7 as I cannot find the
options such as TOOLS so I can make changes.