How to connect two excels 2010 (each on different computer) in REALTIME

[tomazik123]

Hello,

I have two excels 2010 sheets run on two computers, can I connect them in realite the same like there are on the same computer?
I was thinking of DDE, but have no ideal how to do it.
Example:
1 excel formula to 2 excel, when I change sth on 2 excel, I can see it without saving the file. Is it possible?

 

[Marc L]

Hi,​

​

no as Excel is designed (obviously better to use a database software) but maybe with some after market add-in …​

 

[tomazik123]

My computer will be splited on two (ASTER program), I can open two files from one EXCEL.exe, but they don't see in VBA (links are C:\........ intead of [Zeszyt1.xlsm]), so I need to save and refresh to see changes.
Is there any chance to do it in real time, can you recommend some DDE programs to connect them?

 

[mikerickson]

Upload the sheet to Google Documents and allow everyone to edit it.

 

[tomazik123]

It works very bad (2s deley) and here are a lot of functions with doeasn't work on web. So I must do it od desktops.