Need Help w/ shared Excel spreadsheet

By shutup
Aug 6, 2006
  1. I have an Excel spreadsheet, it's a log of the daily tasks. Now it is constantly being changed throughout out the day. It needs to be edited by multiple people, from multiple workstations. I tried using the share workbook option that Excel has but that didn't work. The problem I had was that after someone would make an edit and save the file it didn't refresh on the screens where the file is always open being displayed. Does anyone know of how I could do this? It doesn't necessarily have to be w/ Excel.
  2. boardwalktech

    boardwalktech TS Rookie

    did you ever solve this problem?
  3. matt2971

    matt2971 TS Rookie Posts: 28

    Excel spreadsheets are not designed to be used by multiple users simultaneously. Try MS Access or another database.
  4. SNGX1275

    SNGX1275 TS Forces Special Posts: 10,689   +395

    The post is 10 months old, the dude is probably long gone.

    But if the spreadsheet is fairly simple (no macros) you could use Google's spreadsheet thing, it is basically designed for multiple users.
  5. halo71

    halo71 TS Rookie Posts: 1,090

    Although the original post is kinda old. What we do at work is save the Excel file to a network drive. ANyone that needs access to it, uses it, then makes their saves. Never had any issues with it. Although each workstation user should go into Excel and identify their user ID or whatever (forget where this is in Excel at the moment) so if they are in the spreadsheet and someone else is trying to get into it. The second user will know who they need to ask for access.
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...