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

Këndi publik i sqarimeve

• 

  Kandy91

  • 4 vite më parë

  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 .

  • 4 vite më parë
• 

  pragnatechno

  • 4 vite më parë

  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

  • 4 vite më parë
• 

  Shaun4321

  • 4 vite më parë

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

  • 4 vite më parë
• 

  amwazeindia

  • 4 vite më parë

  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 vite më parë
• 

  SajjadJaved21

  • 4 vite më parë

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

  • 4 vite më parë
  1. 
     Krijuesi i Konkursit

     • 4 vite më parë

     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 vite më parë

Shfaq më shumë komente