I have a computer and a TV.I want to display particular workbook of excel file on the TV ( monitor 2 ) and when I work on my computer monitor ( Monitor 1 ) nothing happens on Monitor 2.I need that because I have linked cells from Workbook 1 and Workbook 2. And lets say I work on Workbook 1, so when I change the linked cells in Workbook 1 they change automatically on Workbook 2 that I need to be displayed on the TV.So no matter what I do on my computer the TV always displays Workbook 2.
I'm using Excel 2003 and Windows XP (with NVidia graphics)