Realtime data update between excels open on two laptops

[Vbalearner85]

Hi,

I have two files which I need to work on two computers.

My question is on technical side of excel.... is there any way we can link two excel files(open on each computer at same time) on independent computers between each other, so that data update on computer 1 excel is reflected on 1 tab in another computer on Realtime basis

 

[CsJHUN]

Hi i made a workbook open event which periodically (1 min) reads all the data from one workbook to another one (which runs the macro).
Depending on the data size of you have this could take some time.

 

[Vbalearner85]

Thanks for your reply...Data size is not too much. Might be 20-50 cells. But my requirement will be fulfilled only for realtime data update and that too file from which I want to update data on another system is fetching live data every sec via python (and file is not saved every time)....System is on same network(Wifi).

Actually issue is When I use that file on same system..it delays other scripts..so want to run it on another system and use live data on my main system

Regards,
PK