Forum Discussion

Iron Contributor

Mar 10, 2018

Solved

Anonymous Sharing: No option to Open file in Excel client

Qingwen Zeng When I share a folder anonymously, I don't get the option to open an excel file using Excel Client. See pics. Any reason why? Any workarounds? One of the excel files is 30MB...

files

SharePoint Online

Gilbert Okello
Mar 10, 2018
Thanks.

I tried using the 'old school' sharing where one authenticates via MSA (microsoft Account?). The result was the same... No option to 'Open in Excel'.

It seems the only option is to download first, make changes then upload (overwrite).

Am curious as to why Microsoft doesn't allow a guest user with Edit permissions to "Open in Excel".

Gilbert Okello

Iron Contributor

Mar 10, 2018

Thanks.

I tried using the 'old school' sharing where one authenticates via MSA (microsoft Account?). The result was the same... No option to 'Open in Excel'.

It seems the only option is to download first, make changes then upload (overwrite).

Am curious as to why Microsoft doesn't allow a guest user with Edit permissions to "Open in Excel".

Deleted

Mar 10, 2018

I tested this just the other day and the open in excel / powerpoint works just fine if you use MSA authenticated access to the files. When your on the page with the excel file, does it show the logged in user in the top right corner or "Guest contributor?"

Gilbert Okello
Iron Contributor
Mar 10, 2018
Removed the guest user.

Restarted the computer

Added guest user again.

Now it shows when using logged in with Microsoft Account.

Thank you!
- StephenRice
  Microsoft
  Mar 12, 2018
  Hi all,
  
  We've definitely heard feedback on being able to open files in the rich Office clients as an anonymous user. This is something we're looking at (though no timeframe). Thanks!
  
  Stephen Rice
  
  OneDrive Program Manager II