How can multiple users enter data in an Excel spreadsheet at once?

Dhaval Kaneriya December 14, 2012
Pinterest Stumbleupon Whatsapp

I have several users sharing a folder, each of the users have a¬†separate¬†excel sheet in the folder that’s filled ddaily.

Instead of having a sheet for each user, I’d like to have one sheet for them all. However, Excel doesn’t seem to let more than one user add input at once.

Is there a solution to this, or alternative application?

Ads by Google

  1. Eyal
    December 18, 2012 at 5:38 am

    You can create a shared workbook and place it on a network location where several people can edit the contents simultaneously. For example, if the people in your work group each handle several projects and need to know the status of each other's projects, the group can use a shared workbook to track the status of the projects. All persons involved can then enter the information for their projects in the same workbook.

    As the owner of the shared workbook, you can manage it by removing users from the shared workbook and resolving conflicting changes. When all changes have been incorporated, you can stop sharing the workbook.

    look at - http://office.microsoft.com/en-us/excel-help/use-a-shared-workbook-to-collaborate-HP010096833.aspx

  2. Rob Hindle
    December 16, 2012 at 12:19 pm

    Perhaps you should migrate the application to a database. MS Access if you have it otherwise maybe you can set up MySQL on a local server.

  3. Roomy Naqvy
    December 14, 2012 at 5:26 pm

    Google Docs, I think, is the only solution which is online, shareable, secure and the best possible that is available.

  4. ha14
    December 14, 2012 at 11:21 am

    check if Asap Excel Utilities can help
    http://www.asap-utilities.com/download-asap-utilities.php

  5. Abba Jee
    December 14, 2012 at 10:50 am

    Excel is not a good database for multiple users, I would suggest you Microsoft Access or use Google Dox i

  6. Junil Maharjan
    December 14, 2012 at 5:15 am

    Use google docs. they have a spreadsheet app where you can create a spreadsheet and share it with whom you want. Everybody to whom you have shared the spreadsheet can view the document as well as edit if the permission to do so is granted to them.

  7. Jose Paolo Gonzales Otico
    December 14, 2012 at 3:33 am

    Excel doesn't offer collaboration. Google docs seems to be the only thing that comes to mind that will allow you to do this at the moment.

  8. Sashritha Peiris
    December 14, 2012 at 3:01 am

    Excel can't do this. But google docs can, google docs is awesome

  9. James Maciel
    December 14, 2012 at 1:42 am

    I use google docs, it's very easy to share and can be accessed anywhere.

Ads by Google