+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Problem linking data between two spreadsheets in Technical; So we have a Sports Day spreadsheet, and on the day I would like to run a second monitor which ...
  1. #1

    Join Date
    Jan 2012
    Posts
    31
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Problem linking data between two spreadsheets

    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.

    Any ideas?

  2. #2

    Join Date
    Jan 2012
    Posts
    31
    Thank Post
    3
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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.



SHARE:
+ Post New Thread

Similar Threads

  1. [MS Office - 2010] Excel: Link to send current spreadsheet as attachment
    By RabbieBurns in forum Office Software
    Replies: 5
    Last Post: 13th August 2010, 09:00 AM
  2. Transferring data between phones
    By crc-ict in forum General Chat
    Replies: 1
    Last Post: 14th February 2008, 10:20 AM
  3. DNS between two domains RESOLVED
    By edie209 in forum Windows
    Replies: 7
    Last Post: 8th November 2007, 08:47 PM
  4. Merging data from two cmis datasets
    By gskelton in forum MIS Systems
    Replies: 1
    Last Post: 5th July 2007, 11:47 AM
  5. Wireless Routing between two wireless routers
    By HodgeHi in forum Wireless Networks
    Replies: 2
    Last Post: 4th August 2006, 06:24 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •