+ Reply to Thread
Results 1 to 3 of 3

How can two or more people work on the same spreadsheet at the same time

  1. #1
    Registered User
    Join Date
    04-21-2019
    Location
    virginia, usa
    MS-Off Ver
    Excel 2016
    Posts
    1

    How can two or more people work on the same spreadsheet at the same time

    Hello,
    I'm a college student and often get group projects. I always have to wait for my the people in my group to finish their part, so I can start mine. I was wondering if there was a way me and group can work on the project at the same time (from more than one computer).

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: How can two or more people work on the same spreadsheet at the same time

    .
    You can post the workbook to MS One Drive.

    You can utilize Excel 365 online version.

    If don't need to collaborate while working on the workbook, each person can have their own copy of the workbook
    on their computer. When finished with their work, they can update the MASTER WORKBOOK (stored on a cloud site).
    This will require all others to wait until the first person is done updating the MASTER WORKBOOK. Each person will then
    need to download the latest version of the MASTER WORKBOOK, prior to starting again with their changes.

    Bottom line : Excel (except for those listed above) is not designed to be accessed by two or more people at the same time.


    The attached contains three workbooks how to check if a file is available.
    Attached Files Attached Files
    Last edited by Logit; 04-21-2019 at 10:15 PM.

  3. #3
    Forum Expert
    Join Date
    10-15-2018
    Location
    MA, USA
    MS-Off Ver
    2010, 2019
    Posts
    1,616

    Re: How can two or more people work on the same spreadsheet at the same time

    With a Office 365 subscription then there is apparently a feature called "co-authoring" which will allow multiple people to update the same workbook.

    Failing that, then under the button "Review" tab you will see a "Share Workbook" button that you can click on. There are some fairly common features that are not supported when in shared mode - you can google for details - but if you don't care about these then this mode may be of use to you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] 2 people opening the same spreadsheet at the same time
    By Tony0731 in forum Excel General
    Replies: 4
    Last Post: 02-21-2019, 11:31 AM
  2. Replies: 5
    Last Post: 01-27-2016, 11:59 AM
  3. Work Schedule - 24/7 - 4 shifts per day, 6 people
    By as519999 in forum Excel General
    Replies: 3
    Last Post: 04-06-2015, 07:33 PM
  4. Replies: 2
    Last Post: 10-25-2014, 05:15 AM
  5. HELP!! How can a forumla work out the amount of people at any time?
    By dhaslett in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2013, 04:26 PM
  6. Need help with a spreadsheet I want people to see on the web
    By pglufkin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2013, 05:28 PM
  7. I need to count the number of people who work before a certain time.
    By nickmessick1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-15-2012, 04:02 PM

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