Dual Screen Excel

Not sure if this belongs here but here we go. When working in excel i always want to look at things on dual screen. So i open the first worksheet normally, then to open the second worksheet i right click on the excel icon and create a new blank workbook and drag and drop the other spreadsheet i need to view there. This works just fine. The issue is when i am trying to link the two spreadsheets that i currently have open together. Nothing happens.

Is there a way to actively link workbooks that have been opened in separate windows?

1. open an excel file normally
2. right click on excel icon and open and select Microsoft Excel x version ( a new workbook should pop open)
3. Drag and drop the spreadsheet you would like to view in that screen

After that the issue I have is being able to link the first spreadsheet in step one with the spreadsheet we opened in step 3.
I know if i stretch the original excel window and open both spreadsheets in the same excel window everything works fine. the question is can it be done when excel is opened in a separate window all together?

Thank you for any help on this.

Danny

Okay the newer version of excel 2013, has a SDI it does allow multiple excel windows and linking via formulas across both independent windows?

If you open Excel full screen, click on the middle button at the top right of the screen to "Restore Down". Now drag the side of the Restored Down window across the two screens. Drag the top and bottom of the Excel window to make it fill the screen. (You might be able to just Restore Up/Maximise.) Now open both workbooks in the same instance of Excel. Use View | Arrange All | Arrange Vertical to split the screen. With luck, you should have one workbook displayed on one screen and the other on the second.

And, because they are in the same instance of Excel, you should be able to link them.