+ Reply to Thread
Results 1 to 8 of 8

Shared Workbook can only be edited by one person at a time instead of multiple people.

  1. #1
    Registered User
    Join Date
    04-08-2019
    Location
    Belgium
    MS-Off Ver
    Office 365 pro plus (2016)
    Posts
    4

    Question Shared Workbook can only be edited by one person at a time instead of multiple people.

    As the title says. I've shared an excel file with another person but whenever that other person is editing the file I'm locked out and vice versa. I've used this sharing feature before but I never had this issue, I don't know why it suddenly happened. Any idea how I can fix this?

    additional info:
    I've done some testing on different files. So a standard .xls file will allow co-authoring in excel online but not in local excel (which is the goal here). An excel document WITH vba macro's that is both saved as .xls and .xlm (2 copies) won't work for either excel online or local excel. I'm not able to pinpoint the issue here. Ideally I want a macro enabled file to be shared for co-authoring in local excel. Not to add new macro's in because that's not supported but I programmed a small search function with vba before the file was shared and no new code shall be added after sharing and this is supposed to be supported.

    The file is located in onedrive.


    PS: I've made a post about this on r/excel also because I need a solution very urgently.
    reddit.com/r/excel/comments/batmyb/shared_workbook_can_only_be_edited_by_one_person/
    Last edited by SouliG; 04-08-2019 at 11:04 AM. Reason: adding link to reddit post

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Shared Workbook can only be edited by one person at a time instead of multiple people.

    Welcome to the forum!

    I cannot find your thread on Mr Excel - what is its title? As you are a new member here, I will post the link for you this time, but if you cross post again, please be aware that you will be required to do this yourself.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-08-2019
    Location
    Belgium
    MS-Off Ver
    Office 365 pro plus (2016)
    Posts
    4

    Re: Shared Workbook can only be edited by one person at a time instead of multiple people.

    Hi I'm new here indeed, thank you. I've added the link to the reddit post

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Shared Workbook can only be edited by one person at a time instead of multiple people.

    Administrative Note:

    I am waiting for you to tell me the title of the thread you have posted on Mr Excel and/or Reddit. There are no links in your post.

    (Note: this requirement is not optional. No help to be offered until the information is provided.)

  5. #5
    Registered User
    Join Date
    04-08-2019
    Location
    Belgium
    MS-Off Ver
    Office 365 pro plus (2016)
    Posts
    4

    Re: Shared Workbook can only be edited by one person at a time instead of multiple people.

    For some reason it didn't save the post with the link which I thought it did. I've made an adjustment for it to work this time.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Shared Workbook can only be edited by one person at a time instead of multiple people.

    Thank you. Here's a live link: https://www.reddit.com/r/excel/comme...by_one_person/

    You may now receive help here.

  7. #7
    Registered User
    Join Date
    04-08-2019
    Location
    Belgium
    MS-Off Ver
    Office 365 pro plus (2016)
    Posts
    4

    Re: Shared Workbook can only be edited by one person at a time instead of multiple people.

    Do I replace it with the one you gave me?

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Shared Workbook can only be edited by one person at a time instead of multiple people.

    No need, thanks.

+ 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. Trying to change the time that I edited a workbook
    By TexasIsNotWhereILive in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2014, 05:57 PM
  2. Replies: 2
    Last Post: 04-17-2014, 09:41 PM
  3. Replies: 1
    Last Post: 04-27-2013, 10:08 AM
  4. Shared Workbook/Workbook to be used by many people
    By BigBas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2012, 08:31 AM
  5. Replies: 0
    Last Post: 09-08-2005, 09:05 AM
  6. Replies: 0
    Last Post: 09-07-2005, 03:05 PM
  7. Replies: 0
    Last Post: 03-31-2005, 02:06 PM

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