Aug 05 2021 08:05 AM
I have O365 business, and I shared an Excel file with an external user (not in our AAD/domain).
They can open the Excel file in their browser with Excel Online, but the "open in desktop app" doesn't show up for them.
Is there a setting I can change to allow this external user to open the file in the full Excel program?
Aug 05 2021 11:45 AM
Aug 05 2021 11:53 AM
Aug 02 2022 11:49 AM
@Shawn Keene To allow "Open in Desktop" functionality, you need to add the person you are collaborating with as a Guest in your Azure Directory. Follow these steps: https://docs.microsoft.com/en-us/azure/active-directory/external-identities/b2b-quickstart-add-guest...
Once your Guest is added, go to the file or folder you would like to share, and enter the Guest email address.
Note: In order for it to work, make sure your org settings allow sharing with guests: https://docs.microsoft.com/en-us/sharepoint/turn-external-sharing-on-or-off
If this worked for you, please give it a thumbs up.
Feb 15 2023 05:38 PM
@olivierlord this may have saved my life! this seemed to work for me, using another email address as a test. If I share this with another person in a different organization would anything on their end prevent the from opening the file in their desktop app?
Feb 15 2023 07:05 PM
@Caseypaulmq Once you give them access in your Azure Directory as guest, right-click on the file or folder to share, then Manage Access, and add their email again. They will need to accept the initial invite to join your Org Directory, then they should have access to the shared file/folder. If they can’t maybe it has to do with their own org security configurations — that, I can’t help with.