Results 1 to 2 of 2

Thread: Updating values between 2 different spreadsheets by 2 different users
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Updating values between 2 different spreadsheets by 2 different users

    Hi all, first time poster here. Hoping someone can help.

    I've created 2 spreadsheets to use in a mock scenario for testing my department's flood response procedures. On the 1st spreadsheet (called Location), I've written a macro to constantly increase the value of the river levels every minute. The 2nd spreadsheet (called Overview) then has links to cell values and has an automatically updating chart based on values from the Location spreadsheet. When I have both spreadsheets open on the same laptop, the Overview spreadsheet automatically updates the values every time the values increase on the Location spreadsheet. But when I have the spreadsheets open on different computers, the values do not automatically update. For the scenario, I will need to have the spreadsheets open on different computers as staff will be based in different offices. Both spreadsheets are on our shared network drive.

    I have tried sharing the Location spreadsheet, and having this open on both computers. This does work, but it can only update every 5 minutes, which is not often enough, and it also messes up the macros on the spreadsheet.

    Does anyone have any suggestions? I'm using Excel 2013.

    Thanks

  2. #2
    Board Regular Drrellik's Avatar
    Join Date
    Apr 2013
    Location
    East Coast, South Carolina
    Posts
    738
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Updating values between 2 different spreadsheets by 2 different users

    if you are able to leave both workbooks in the same location folder and give permission for the other locations to share you might get better results, just a thought.
    There are 10 types of people in this world, those who understand binary, and those that dont.


    - forum use guidelines, forum rules and terms of use

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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