When a excel file is shared, multi users on different PC's can work in the same excelfile.
Problem is that there is no possibility to see the changes in real time.
UserA changes only values in column F, user B changes only values in Column G, userC changes only values in Column H
The file is on a central share.
Because sharing the file does not do what I want, I am looking for an alternatif.
When userA changes a value in a cell in column F, the change must be "immediate" seen by Users B and C.
So I am looking for a method that when a cell is changed, a package is send to the other computers - Users with te file open.
I was thinking on a ontime event that controls let us say every 5 seconds if a textfile is recieved, and when the package is recieved, the text file is read, and the cell is updated.
Is there somebody with experience about sending a textfile to workstations - users, with the info wich cell is changed, and what the new value is.
And then add the change in the cell?
Or is there an other workarround?