If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Basketball Stats
I want to use 2 monitors. 1 so the radio man can see the stats up-to-date immediately. 1 to enter the current plays. What is the best way? If i try to link 2 workbooks it won't update automatically. It is set to automatic calculation. If I try to use the same workbook with 2 sheets it won't update automatically. -- old coach |
#2
|
|||
|
|||
Basketball Stats
2 monitors on one PC, I assume?
You can set up the PC to show one Excel window spanning the two monitors (don't ask me how, but I've seen it done) Then have the two sheets of your workbook in separate windows within the one Excel window (Window New Window), and arrange them side by side (Window Arrange Vertical). One should now appear on each monitor and, being in the same instance of Excel they will certainly update as you enter data in automatic calculation mode). If your monitors are on different PCs then Excel is not the program you should be using - Access would be better as it is designed for multiple simultaneous use of the same data by different people. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Thread Tools | |
Display Modes | |
|
|