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

  • Status: Closed
  • Hadiah: $10
  • Entri Diterima: 28

Deskripsi Kontes

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

Keahlian yang Disarankan

Papan Klarifikasi Publik

  • Kandy91
    Kandy91
    • 1 bulan yang lalu

    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 .

    • 1 bulan yang lalu
  • pragnatechno
    pragnatechno
    • 1 bulan yang lalu

    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

    • 1 bulan yang lalu
  • Shaun4321
    Shaun4321
    • 2 bulan yang lalu

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

    • 2 bulan yang lalu
  • amwazeindia
    amwazeindia
    • 2 bulan yang lalu

    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

    • 2 bulan yang lalu
  • SajjadJaved21
    SajjadJaved21
    • 2 bulan yang lalu

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

    • 2 bulan yang lalu
    1. dangorka
      Penyelenggara Kontes
      • 2 bulan yang lalu

      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

      • 2 bulan yang lalu

Lihat lebih banyak komen

Bagaimana untuk memulai sebuah kontes

  • Buat kontes Anda

    Buat Kontes Anda Cepat dan mudah

  • Dapatkan jutaan entri

    Dapatkan Jutaan Entri Dari seluruh dunia

  • Pilih entri terbaik

    Pilih entri terbaik Unggah file - Mudah!

Buat sebuah Kontes Sekarang atau Gabung dengan kami Hari ini!