Work with 3 users on 3 different PC's in the same excelfile, see changes real time

  • Hello,


    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.
    Situation:
    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.


    Method:
    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?


    Thanks


    aisietie

  • Re: Work with 3 users on 3 different PC's in the same excelfile, see changes real tim


    I think you're barking up the wrong tree entirely with Excel, it is fundamentally not designed to do this.


    I'd look for other solutions, have a look at access, again you won't get data pushes but it will allow multi-user access. I'd also look at what google offers, I've a suspicion that google docs may offer something similar to this, but I've never used them

  • Re: Work with 3 users on 3 different PC's in the same excelfile, see changes real tim


    Google Docs can do this; I haven't played with it much, but I've seen real-time (or close to real-time) updating work on them.
    As for how to do it in Excel, if you're looking for something that's sensibly robust, you'll looking at a massive project.

  • Re: Work with 3 users on 3 different PC's in the same excelfile, see changes real tim


    We had the same challenge at work, and decided to use "google spreadsheet" for the task.
    Updates are shown within a 2 sec delay, and multiple people can work at once.


    What I don't like with it so far, is the laking of some hotkeys and the print alternative.

  • Re: Work with 3 users on 3 different PC's in the same excelfile, see changes real tim


    So the idea sending a textfile to a Workstation with the value and range of the cell that is updated, and an application.ontime that does a check if a file is recieved, import the textfile and places the info in the cell, is not feasible.


    Problem is that there are other macro's in the sheet, and google docs does not support vba macro's.


    aisietie

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!