+ Reply to Thread
Results 1 to 6 of 6

Sharing questions Office 365

  1. #1
    Banned User!
    Join Date
    03-16-2019
    Location
    Florida
    MS-Off Ver
    Office 365
    Posts
    8

    Question Sharing questions Office 365

    I'm currently having some problems with sharing since I'm running Office 365 and am taking a course on Linked In Learning pertaining to Excel 2016. The only difference between the two I'm aware of is saving in the cloud automatically as changes are made.

    It's a great course but Office uses the "Co-Authoring" function which the course says nothing about. I can do a legacy share and change tracking no problem. But of course it can't be edited by more than one person at a time.

    I click "Share" in the upper right, ensuring the workbook is not currently shared and I get a dialog on the right asking to enter email addresses. They are sent but Co-Authoring is not enabled.

    Any help would be greatly appreciated!

  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,335

    Re: Sharing questions Office 365

    Make sure that you have enabled editing in the share dialog.
    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
    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,335

    Re: Sharing questions Office 365

    You have marked the thread as solved, but not responded to my suggestion - should we assume that it worked?

  4. #4
    Banned User!
    Join Date
    03-16-2019
    Location
    Florida
    MS-Off Ver
    Office 365
    Posts
    8

    Re: Sharing questions Office 365

    That did work and thank you!

    I had been selecting the "Can Edit" option with an unshared workbook but still was unable to edit simultaneously. But it turned out I was working with a local copy. Once I shared a copy on OneDrive, Co-authoring worked fine.

    But editing done in the cloud was not simutaneously updated in real time. I'm assuming it's not supposed to? But upon closing, and reopening the changes updated. Is there a way to refresh the changes without closing and reopening?

  5. #5
    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,335

    Re: Sharing questions Office 365

    You can use the refresh button on the data ribbon to refresh your connections.

  6. #6
    Banned User!
    Join Date
    03-16-2019
    Location
    Florida
    MS-Off Ver
    Office 365
    Posts
    8

    Re: Sharing questions Office 365

    Thanks again!

+ 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] Sharing a workbook with users without Office
    By p3rlend in forum Excel General
    Replies: 2
    Last Post: 08-24-2016, 11:29 AM
  2. access in office sharing database
    By Joel10952 in forum Access Tables & Databases
    Replies: 6
    Last Post: 06-23-2013, 10:50 PM
  3. How we unprotect Sharing Password if Vba Project is unviewable ........ Creak Sharing Pas
    By shahidanwar0 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2013, 01:10 PM
  4. Workbook VBA Project Reference will not migrate form Office 2010 to Office 2002
    By DAve Bradbury in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2013, 07:43 AM
  5. [SOLVED] Office 2003 merge questions
    By deusy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-16-2006, 10:05 AM
  6. [SOLVED] Setup/ sharing questions
    By sbhayes in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2006, 03:25 PM
  7. Office XP Exel - files sharing issue/question
    By mikebach in forum Excel General
    Replies: 0
    Last Post: 12-14-2005, 03:40 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