Two displays, one showing one sheet only

[rireland]

I use Excel for a sports scoring system. Sheets 1 to 5 have all the input info & minor placings. Sheet 6 is the results of the previous 5 sheets and the one the crowds want to see. What I want to do is connect a projector to the video output of the laptop & have sheet 6 permanently displayed (while we still input info to sheets 1-5.) Project to big screen for all to see! So:
1. Can the video output be different to the laptop display ( & if not is there a card I can buy to acheive that)
2. How can you make the second video ouput be a certain sheet of a workbook?
Thanks
Richard

 

[SydneyGeek]

A bit of hand-waving here because I haven't set one up, but did some research on the possibility a while back...

If your funds stretch to it, the way to go is with a dual-monitor setup. If you are using the on-board graphics, buy a card that fits into your PC -- you'll need to check out what to get here. Some cards have dual monitor outputs.

Anyway, what you do is:
1. Open the working copy on monitor 1
2. In Excel, Window> New Window and put that copy on monitor 2. Select Sheet6. This will be the monitor that feeds the output to the projector.

You work away on the main copy, updating Sheets 1-5. Monitor2 displays the collated results. Corwd is happy. You're happy. Or something like that

Denis

 

[rireland]

dual display

Thanks for fast reply Denis.
Looks like the s/w is solved - the hardware might be the problem. Possibly the wrong forum to ask, but what I need, I think, is a PCMCIA card with dual video outputs? Do they exist?
Quick research found a few for desktops at huge prices, designed for v high res gaming. Don't need speed or res, just 2 outputs!
Richard

 

[mrhartley]

Hi,

Dont know if this helps but my Dell Laptop has a docking station that has two video outputs which I use for dual monitors.

Maybe a docking station with two video outputs might be cheaper than what you have found.

~Mark