+ Reply to Thread
Results 1 to 8 of 8

many user open same excel

  1. #1
    Registered User
    Join Date
    05-07-2008
    Posts
    22

    Arrow many user open same excel

    Hi we have few staff that sharing same Microsoft Excel Worksheet, at same time, and they need to search, edit(Update). is there any way to make such rules? currently if A user open other unable to edit or update.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: many user open same excel

    ... and that is a good thing.

    Excel does not support simultaneous access by multiple users very well. Although there are settings to share a workbook, so several users can edit and change data at the same time, these shared workbooks tend to become corrupt, lose data, act funny and are impossible to troubleshoot.

    If you need a true multi-user solution, consider a database with a front end, like Access, SharePoint, MySQL, etc.

    cheers,

  3. #3
    Registered User
    Join Date
    05-07-2008
    Posts
    22

    Re: many user open same excel

    Thank you very much teylyn, we use excel to cut cost

  4. #4
    Registered User
    Join Date
    02-25-2010
    Location
    Abu dhabi
    MS-Off Ver
    Excel 2007, Excel 2010, Excel 2013
    Posts
    24

    Re: many user open same excel

    You can share the workbook. Click on Review>Share Workbook>under editing tab check the box which reads"Allow changes by more than one user at the same time. This also allows workbook merging.".

    Now your workbook can be edited by multiple user.

    WARNING: Sharing might corrupt the workbook.!!!!!!!!!!!!!!!!!!!!

  5. #5
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: many user open same excel

    @preond, I think I already said that above. No need to repeat what's already been posted.

    @rashim
    we use excel to cut cost
    That's fine. But the most cost effective solution is not necessarily the best solution, i.e., it does not mean that Excel will do what you need to be done, just because you don't have to spend money to use it. If you have Excel, you probably also have Access. Access does support multiple users at the same time, so you may want to design a solution that is

    - cost efficient (because you already own the licenses)
    - keeps your data intact (which an Excel shared workbook will not do)
    - is much more flexible with regards to user privileges
    - can be queried by multiple users at the same time using reports or an Excel front-end for viewing data.

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: many user open same excel

    Access is not always available, I've worked for companies that had Excel but not Access. It is worth checking though because multi-user Excel will probably end in problems as Teylyn says
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  7. #7
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: many user open same excel

    some things to consider:
    1 how many users at once
    and often this will happen (20 users occasionally accessing is not really a problem but 20 users using it constantly would be)
    2,layout
    see attached
    3. user education
    they must save before entering if they are likely to overwrite cells used by others and always accept changes by others(make sure the ask me selection option is changed)
    4 housekeeping
    you will need to monitor the sharing to make sure users are not logged in multiple times.
    periodically make sure everyone has closed and saved then unshare reshare the work book
    keep an unshared back up copy yourself once a day or more regularly
    5. if things go wrong stop every one using the shared workbook.
    get each of them to save /as a local copy so you can cross check data.
    unshare workbook if you can, then reshare and get everyone one at a time to re enter their data.
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  8. #8
    Registered User
    Join Date
    05-07-2008
    Posts
    22

    Re: many user open same excel

    my company only have excel, we don't have access, due to Policy , currently we only have 5 user that use same file.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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