Excel 2007 - Viewing 2 sheets - problem with links
 

Hello,
When I view two sheets from the same workbook:

In Sheet 1, I click on a link to another sheet, Excel takes me there in the
Sheet 2 window. I wanted Sheet 2 to stay where it was, and for the link to
switch sheets in the Sheet 1 window.
This problem only occurred when I started using 2007, so I am hoping it is
just a setting.
Thanks!