So we have a Sports Day spreadsheet, and on the day I would like to run a second monitor which would display the current leaders to anyone that wanted to see. To do this I would have my normal data entry spreadsheet, then a second spreadsheet that just reads the data from the other for display purposes on the second monitor.
The issue I'm hoping for ideas on, is in order to run Excel on two monitors, you have to open two instances. When you do this the cells that link into the other spreadsheet no longer autoupdate. It still works if you go into the UI Ribbon > Data > Edit Links > Update values, but that's not very practical on the day.
Found one option - not entirely sure why it works. If I embed a spreadsheet in Powerpoint, then make a connection to my data spreadsheet with a few references to cells in the other spreadsheet it updates in real time. Quite why it works like this, and not between instances of Excel I'm not sure.
Last edited by Tricky; 10th July 2013 at 02:19 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)