I would like to get two separate workbooks displayed on 2 monitors. I have 2 instances of excel active. Workbook 1 is displayed on my computer monitor. Workbook 2 is displayed on my TV. The problem I am having is that Workbook 2 gets all its data from CHANGING data in Workbook 1, however whenever the data changes in Workbook 1, Workbook 2 does not reflect those changes.

If I have both workbooks open just using the computer monitor the data is updated correctly on workbook 2. Am I missing something here.