View different worksheets from same workbook on multiple screens/monitors?

[ERoemer]

I have Excel workbooks with several worksheets in each workbook. I also have multiple monitors connected to my computer, including an LCD projector, set up in "extended desktop" mode. I would like to open a workbook and display different worksheets from that workbook on a separate screen. I can open multiple windows in the workbook, and tile different worksheets, but it won't let me drag a worksheet to another monitor--it stops at the edge of one of the screens. Other programs let me drag across the different screens.

Is there a way to open a workbook and drag, or show, different worksheets from that workbook onto different monitors (different "areas" of my "extended desktop")?

I can't just open multiple copies of the file, because I want to do live editing where entering info in a worksheet on one screen updates the info in a worksheet shown on another screen.

[Crawfinator1]

I can do it on my two-screen setup...

Simply manually extend excel across both screens... then goto view-new window-arrange all-as you like but i assume you would do it vertically.