Can't open document shared with me in Word desktop application

%3CLINGO-SUB%20id%3D%22lingo-sub-189357%22%20slang%3D%22en-US%22%3ECan't%20open%20document%20shared%20with%20me%20in%20Word%20desktop%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189357%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20access%20to%20an%20organisation's%20SharePoint%20Online%20environment%20via%20the%20partner%20access%20option.%20I%20can%20open%20Office%20documents%20in%20the%20browser%2C%20but%20when%20I%20try%20to%20open%20in%20the%20desktop%20applications%2C%20I%20just%20keep%20getting%20prompted%20for%20my%20email%20address%20and%20password.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20have%20any%20problems%20opening%20documents%20stored%20in%20my%20organisation's%20tenant.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20addition%20to%20my%20login%20prompts%2C%20I%20get%20an%20option%20to%20%22Add%20this%20account%20to%20Windows%22.%20I'm%20not%20sure%20what%20that%20is%20about%2C%20as%20the%20PC%20I'm%20on%20is%20domain%20joined%20and%20I'm%20logged%20on%20with%20the%20account.%20I%20can%20skip%20this%20step%2C%20so%20I'm%20not%20sure%20it%20is%20relevant%20to%20the%20issue.%20If%20I%20do%20try%20to%20add%20the%20account%2C%20it%20fails.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20932px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F33391i81726ECB873EA8F4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Sketch.png%22%20title%3D%22Sketch.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-189357%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-210155%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20document%20shared%20with%20me%20in%20Word%20desktop%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-210155%22%20slang%3D%22en-US%22%3EShouldn%E2%80%99t%20be%20they%20are%20technically%20the%20same.%20So%20you%20are%20a%20site%20collection%20admin%20on%20the%20site%20your%20trying%20to%20edit%20the%20files%20on%3Fso%20if%20you%20navigate%20to%20the%20site%20and%20try%20to%20edit%20the%20files%20using%20excel%20%2F%20word%20from%20the%20site%20itself%20direct%20you%20cannot%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-210150%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20document%20shared%20with%20me%20in%20Word%20desktop%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-210150%22%20slang%3D%22en-US%22%3E%3CP%3EI%20just%20tried%20opening%20an%20Excel%20file%20shared%20via%20a%20user's%20OneDrive%20for%20Business%20site%20at%20the%20same%20tenant.%20This%20opened%20fine%20in%20the%20Excel%20desktop%20application.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wonder%20if%20the%20behavior%20is%20different%20depending%20on%20whether%20the%20document%20is%20located%20in%20ODfB%20or%20a%20SharePoint%20site%20collection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-190482%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20document%20shared%20with%20me%20in%20Word%20desktop%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-190482%22%20slang%3D%22en-US%22%3ENot%20true.%20That%E2%80%99s%20only%20if%20you%20don%E2%80%99t%20already%20have%20a%20license%20somewhere%20else%20%3A).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-190394%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20document%20shared%20with%20me%20in%20Word%20desktop%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-190394%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20only%20a%20Guest%20User%20or%20an%20External%20User%20on%20SharePoint%20Online%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExternal%20users%20can%20perform%20the%20following%20tasks%3A%3C%2FP%3E%3CP%3EUse%20Office%20Online%20for%20viewing%20and%20editing%20documents.%20If%20your%20plan%20includes%20Office%20Pro%20Plus%2C%20they%20will%20not%20have%20the%20licenses%20to%20install%20the%20desktop%20version%20of%20Office%20on%20their%20own%20Computers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat's%20all%20you%20can%20only%20viewing%20and%20editing%20documents%20Online.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-190336%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20document%20shared%20with%20me%20in%20Word%20desktop%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-190336%22%20slang%3D%22en-US%22%3ENot%20sure%20what%20a%20partner%20account%20is%2C%20I've%20done%20it%20over%20being%20invited%20as%20a%20guest%20to%20a%20group%20%2F%20team%2C%20and%20just%20invited%20direct%20using%20old%20sharing%20%2F%20access%20dialog%20in%20SharePoint.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-190333%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20document%20shared%20with%20me%20in%20Word%20desktop%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-190333%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1803%22%20target%3D%22_blank%22%3E%40Paul%20Pascha%3C%2FA%3E%26nbsp%3B-%20it%20looks%20like%20this%20requires%20an%20Enterprise%20Mobility%20%2B%20Security%20license%20to%20configure%2C%20so%20this%20setting%20isn't%20available%20in%20this%20client's%20tenant%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F33555i017AC95864AD5B0B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22RestrictAccessBasedOnDeviceOrNetworkLocation.png%22%20title%3D%22RestrictAccessBasedOnDeviceOrNetworkLocation.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F875%22%20target%3D%22_blank%22%3E%40Christopher%20Webb%3C%2FA%3E%26nbsp%3B-%20thanks%20for%20confirming%20it%20works%20for%20you.%20Are%20you%20accessing%20the%20tenant%20using%20a%20Office%20365%20partner%20account%2C%20or%20purely%20as%20an%20invited%20user%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-189946%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20document%20shared%20with%20me%20in%20Word%20desktop%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189946%22%20slang%3D%22en-US%22%3E%3CP%3EAny%20idea%20how%20Access%20Control%20settings%20for%20the%20SharePoint%20Online%20tenant%20the%20document%20is%20shared%20from%20are%20configured%3F%20There's%20the%20option%20to%20configure%20limited%20(web-only)%20access%20from%20unmanaged%20devices.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20this%20blog%20for%20more%20information%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fblogs.technet.microsoft.com%2Fwbaer%2F2017%2F10%2F08%2Fsite-scoped-conditional-access-policies-in-sharepoint-online%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fblogs.technet.microsoft.com%2Fwbaer%2F2017%2F10%2F08%2Fsite-scoped-conditional-access-policies-in-sharepoint-online%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-189893%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20document%20shared%20with%20me%20in%20Word%20desktop%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189893%22%20slang%3D%22en-US%22%3EI%20can%20confirm%20using%20same%20office%20desktop%20client%20can%20open%20files%20from%203%20different%20tenants%20so%20that%E2%80%99s%20not%20the%20issue%20%3A).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-189889%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20document%20shared%20with%20me%20in%20Word%20desktop%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189889%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20set%20up%20as%20a%20site%20collection%20administrator%20on%20the%20client's%20site%20collection.%20I%20have%20an%20E5%20license%20on%20my%20company's%20tenant.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tested%20with%20an%20Office%20365%20account%20from%20the%20client's%20tenant.%20That%20works%20as%20expected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20sounds%20like%20the%20Office%20desktop%20apps%20currently%20do%20not%20support%20opening%20documents%20from%20another%20tenant%20that%20you%20have%20been%20granted%20access%20to.%20However%2C%20the%20user%20interface%20still%20gives%20you%20the%20option%20to%20try%2C%20but%20throws%20you%20into%20an%20infinite%20loop%20of%20credential%20prompts.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-189542%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20document%20shared%20with%20me%20in%20Word%20desktop%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189542%22%20slang%3D%22en-US%22%3EUsing%20any%20%E2%80%9Cshare%E2%80%9D%20links%20do%20not%20provide%20office%20client%20editing.%20You%20must%20be%20assigned%20access%20to%20the%20site%20using%20a%20guest%20account%20either%20through%20teams%20%2F%20groups%20guest%20access%20or%20being%20added%20directly%20to%20the%20resource%20in%20Sharepoint%20using%20the%20classic%20experience.%3CBR%20%2F%3E%3CBR%20%2F%3EMicrosoft%20has%20hinted%20at%20changing%20this%20in%20the%20near%20future.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-189371%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20open%20document%20shared%20with%20me%20in%20Word%20desktop%20application%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-189371%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Ivan!%3C%2FP%3E%3CP%3EHow%20has%20the%20document%20been%20shared%20with%20you%3F%20Has%20anyone%20shared%20the%20entire%20SharePoint%20site%20with%20you%20to%20the%20O365%20account%20you%20have%20in%20your%20organization%20or%20have%20only%20the%20document%20been%20shared%20as%20a%20link%20to%20Your%20O365%20account%3F%3C%2FP%3E%3CP%3EWhat%20type%20of%20license%20do%20you%20have%20with%20the%20other%20organization%3F%20Does%20it%20contain%20Office%20or%20can%20You%20only%20use%20Office%20online%20there%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

I have access to an organisation's SharePoint Online environment via the partner access option. I can open Office documents in the browser, but when I try to open in the desktop applications, I just keep getting prompted for my email address and password.

 

I don't have any problems opening documents stored in my organisation's tenant.

 

In addition to my login prompts, I get an option to "Add this account to Windows". I'm not sure what that is about, as the PC I'm on is domain joined and I'm logged on with the account. I can skip this step, so I'm not sure it is relevant to the issue. If I do try to add the account, it fails.

Sketch.png

11 Replies
Highlighted

Hi Ivan!

How has the document been shared with you? Has anyone shared the entire SharePoint site with you to the O365 account you have in your organization or have only the document been shared as a link to Your O365 account?

What type of license do you have with the other organization? Does it contain Office or can You only use Office online there?

Highlighted
Using any “share” links do not provide office client editing. You must be assigned access to the site using a guest account either through teams / groups guest access or being added directly to the resource in Sharepoint using the classic experience.

Microsoft has hinted at changing this in the near future.
Highlighted

I am set up as a site collection administrator on the client's site collection. I have an E5 license on my company's tenant. 

 

I have tested with an Office 365 account from the client's tenant. That works as expected.

 

It sounds like the Office desktop apps currently do not support opening documents from another tenant that you have been granted access to. However, the user interface still gives you the option to try, but throws you into an infinite loop of credential prompts. 

Highlighted
I can confirm using same office desktop client can open files from 3 different tenants so that’s not the issue :).
Highlighted

Any idea how Access Control settings for the SharePoint Online tenant the document is shared from are configured? There's the option to configure limited (web-only) access from unmanaged devices.

 

See this blog for more information:
https://blogs.technet.microsoft.com/wbaer/2017/10/08/site-scoped-conditional-access-policies-in-shar...

Highlighted

@Paul Pascha - it looks like this requires an Enterprise Mobility + Security license to configure, so this setting isn't available in this client's tenant:

RestrictAccessBasedOnDeviceOrNetworkLocation.png

 

 

@Deleted - thanks for confirming it works for you. Are you accessing the tenant using a Office 365 partner account, or purely as an invited user?

Highlighted
Not sure what a partner account is, I've done it over being invited as a guest to a group / team, and just invited direct using old sharing / access dialog in SharePoint.
Highlighted

You are only a Guest User or an External User on SharePoint Online:

 

External users can perform the following tasks:

Use Office Online for viewing and editing documents. If your plan includes Office Pro Plus, they will not have the licenses to install the desktop version of Office on their own Computers.

 

That's all you can only viewing and editing documents Online.

 

 

Highlighted
Not true. That’s only if you don’t already have a license somewhere else :).
Highlighted

I just tried opening an Excel file shared via a user's OneDrive for Business site at the same tenant. This opened fine in the Excel desktop application.

 

I wonder if the behavior is different depending on whether the document is located in ODfB or a SharePoint site collection.

 

Highlighted
Shouldn’t be they are technically the same. So you are a site collection admin on the site your trying to edit the files on?so if you navigate to the site and try to edit the files using excel / word from the site itself direct you cannot?