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.
|
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 |
All times are GMT +1. The time now is 08:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com