How to remove "Sites" from Office 365 as connected service

ThatGuy897669 26 Reputation points

In a new Office 365 migration I am trying to get rid of my file server. As such I have migrated all shared content by department to Sharepoint library and added a shortcut to each user's One Drive for their department's Sharepoint library. This works great until someone opens something using a desktop app via the "Sites" connection rather than the "One Drive" connection. When they open it via Sharepoint they get all sorts of merge conflicts and fail to upload changes. When they open/close it via the locally sync'd copy through One Drive all is well, (as far as I know, although how One Drive handles merge conflicts behind the scenes I don't know).

From some reading it seems as if this would all work better if I could enable "AutoSave" by default in Excel/Word, however they use many blank forms and would be dismayed at constantly over-writing their forms.

I would like to prevent them from opening things locally via Sharepoint. Is there any way to remove the "Sites" option from the connected services in Excel/Word while retaining their One Drive connected service? From my reading it seems that all registry keys that deal with this are an all or nothing option.

Thanks in advance

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,520 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 17,066 Reputation points Microsoft Vendor

    Hi @ThatGuy897669 ,
    As far as I know if you sign to Office and you will connect to OneDrive for Business automatically and you cannot remove it manually.
    I suggest you refer to this support article and confirm if this will help you:

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments