Sharing Excel data updated every 5 seconds with three different Excel users

  • Status: Closed
  • Prize: $10
  • Entries Received: 28

Contest Brief

I have an Excel file, running 24/7 on virtual machine, automatically downloading new data every 5 seconds. Is there any way to quickly share this data to three different Excel sheets, used by three different users (from three different computers?). So every 5 seconds when main file is updated, all other users can see updated values on their side.

Person suggesting the best solution will be awarded for the contest

Thanks,
Dan

Recommended Skills

Top entries from this contest

View More Entries

Public Clarification Board

  • Kandy91
    Kandy91
    • 3 years ago

    HI , are the 3 users using same type of file in server , next thing is the file in users computer is just for view purpose or they will edit on the file .

    • 3 years ago
  • pragnatechno
    pragnatechno
    • 3 years ago

    hey
    Proposed solution:
    On the same server deploy one api. which will result the desired result we want on 3 excels.
    now 3 excels will be VBA which will call this API every 5 seconds and give the latest values from the excel

    • 3 years ago
  • Shaun4321
    Shaun4321
    • 3 years ago

    What system is your virtual machine hosted on? Are they both Windows operating systems or Linux to Windows?

    • 3 years ago
  • amwazeindia
    amwazeindia
    • 4 years ago

    You can do this by having a common drop box or google drive folder. The workbook need to be saved into the dropbox folder in your computer. Any changes you make will be reflected on the folder and will be in sync with the dropbox folder in your users computers. There are YouTube tutorials on how to achieve this in detail. You either look them up or i can send you a link. Let me know. Thank you. Be safe

    • 4 years ago
  • SajjadJaved21
    SajjadJaved21
    • 4 years ago

    https://www.ablebits.com/office-addins-blog/2017/08/02/excel-shared-workbook-share-file-multiple-users/

    • 4 years ago
    1. dangorka
      Contest Holder
      • 4 years ago

      That's not what I need, one main Excel sheet (which isn't saved in a local network) update every 5 seconds and every 5 seconds changes in the sheet must appear in three other independent sheets

      • 4 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!