Forum Discussion
Excel Survey Option Missing from Excel Online
Some of our users have reported that they are no longer able to create Excel Surveys from within Excel Online. I've spot verified that the option does appear to be missing. I'm searching to see if th...
I never used Surveys, thus can't say how it was before, but now i see no Survey button in the Ribbon as well.
Perhaps the issue is the same as with SPO site collections No Excel survey option when you click +new in a SharePoint Online library. Survey requires anonymous sharing. In our tenant it's prohibited, and even if we have New->Excel Survey menu item for OneDrive, Excel itself disables functionality.
I didn't play with OneDrive Admin Center to check above, just my guess.
Thanks Sergei, your guest is right. For those of you who do not see your Excel Survey option while editing your Excel Online, please approach your Office 365 Global Administrator and get him/her to make the following changes.
Global Administrator logins on to O365. Go to Admin Centers, click OneDrive, click Sharing.
Let users share SharePoint content with external user [On]
Users can share with:
Set this to: [Anyone, including anonymous users]
Let users share OneDrive content with external users [On]
Users can share with:
Set this to:[Anyone, including anonymous users]
Further down you can set your own Default sharing links
My case I set it to:
* Internal - only people in the organization
Anonymous access links:
Links expire within
[0] days
File permissions
[View and edit]
Folder permissions
[View, edit and upload]
What can external users do
I do not check for the following:
[ ]External users must accept sharing invitations using the same account that the invitations were sent to (* I do not check)
[ ]Let external users share items they don't own (* I do not check)
Click Save.
It solved for me and my colleagues. Excel Survey options reappeared again while editing Excel Online.
Good luck !!
Global Administrator logins on to O365. Go to Admin Centers, click OneDrive, click Sharing.
Let users share SharePoint content with external user [On]
Users can share with:
Set this to: [Anyone, including anonymous users]
Let users share OneDrive content with external users [On]
Users can share with:
Set this to:[Anyone, including anonymous users]
Further down you can set your own Default sharing links
My case I set it to:
* Internal - only people in the organization
Anonymous access links:
Links expire within
[0] days
File permissions
[View and edit]
Folder permissions
[View, edit and upload]
What can external users do
I do not check for the following:
[ ]External users must accept sharing invitations using the same account that the invitations were sent to (* I do not check)
[ ]Let external users share items they don't own (* I do not check)
Click Save.
It solved for me and my colleagues. Excel Survey options reappeared again while editing Excel Online.
Good luck !!
Our organization got same problem too, but your advise is such a big help. Issue was resolved.
Thank you.
John
