+ Reply to Thread
Results 1 to 5 of 5

Multiple user on one excel file access issues/inputting data

  1. #1
    Forum Contributor
    Join Date
    08-08-2012
    Location
    USA, CA
    MS-Off Ver
    Excel 2007
    Posts
    131

    Multiple user on one excel file access issues/inputting data

    Hello,

    I am trying to set up a workbook to have multiple users put in data into their respective cells. Since the excel file is accessed by various users, it prevents them from entering the data. Is there any way around this issue?

    Thank you all,

    Newb

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Multiple user on one excel file access issues/inputting data

    Unfortunately no. If you want to have multiple users access and update a file at the same time you'll need to use a different program, preferably a database program like Access, Oracle, or similar. The file containing the data would be the backend, and each user would have a Front-End (or client) that they use to interact with the backend, which allows for multiple users to make updates to the backend at the same time. Excel does not have that functionality.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Contributor
    Join Date
    08-08-2012
    Location
    USA, CA
    MS-Off Ver
    Excel 2007
    Posts
    131

    Re: Multiple user on one excel file access issues/inputting data

    Doesn't excel 2010 have this functionality, called share workbook

  4. #4
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Multiple user on one excel file access issues/inputting data

    I've never used Excel 2010, but if the share workbook feature is what you're looking for, here's some information I found on it:
    http://office.microsoft.com/en-us/ex...005202595.aspx

  5. #5
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Multiple user on one excel file access issues/inputting data

    Excel shouldn't have this functionality, it's horrible and causes all sorts of nastiness

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1