Forum Discussion

EricDavisTech's avatar
EricDavisTech
Bronze Contributor
Sep 07, 2017
Solved

What version of Excel (on Windows) is required to do co-authoring?

I recently say this post: https://blogs.office.com/en-us/2017/08/31/new-to-office-365-in-august-enriching-teamwork/  That says Excel real time co-authoring is now generally available.  What version of excel (on Windows) is required to make this work?  

29 Replies

  • John Gruber's avatar
    John Gruber
    Brass Contributor

    I had issues with co-authoring. I had to make two changes:

     

    1. https://support.microsoft.com/en-us/help/3185078/how-to-switch-from-semi-annual-channel-to-monthly-channel.
    2. Disable "Refresh data when opening the file" on the pivot tables in the workbook.
     
    To disable "Refresh data when opening the file":
    1. Open the workbook.
    2. Highlight a PivotChart.
    3. In the Analyze ribbon click Options.
    4. Go to the data tab and uncheck "Refresh data when opening the file".
    You may need to repeat steps 2-4 on each PivotChart.

     

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Eric,

     

    co-authoring is available as of version 1707 build 8326.2058.

     

    • Rob Barker's avatar
      Rob Barker
      Iron Contributor

      I have two users running Version 1708 Build 8431.2236 ...higher than the stated requirements for desktop Excel co-authoring. Neither of them can open an Excel that I shared with them from my OneDrive for Business. They can co-author in Excel online (i.e., the browser version) but they cannot co-author in Excel desktop (the file will not open for them if I already have it open.) If I'm not in the file, they can open it individually and save changes, which I see later after they've closed it and I re-open it.

       

      They are on Office 365 semi-annual channel and I'm on Monthly targeted channel. They do not have the AutoSave button in the upper left corner of Excel (which I believe it supposed to provide a good visual indicator that the user has the correct version for co-authoring.)

       

      How do I get them co-authoring in Excel desktop? What version is required?

    • Rob Barker's avatar
      Rob Barker
      Iron Contributor

      I have a user that is running 1708 build 8431.2153 (and I'm running 1712 build 8827.2117) and I shared a workbook with him that is stored in my ODFB, but he doesn't see co-authoring (i.e. there is no AutoSave button for him.) Any idea why that would occur?

Resources