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.
Didn't solve it in our case. Tenant is configured as per article's requirements
- Zhongzhong_Li
Microsoft
The Excel survey has dependency on "external sharing / anonymous access links" feature. All the responders are actually anonymous users when they try to submit the survey, and that will requires them to have "edit" permission with the anonymous access link. Could you check if you open the Excel workbook with the anonymous access link, do you have "edit" permission?- Hi, external sharing / anonymous access is allowed. However the links created do expire after 60 days. Is it this 'intelligent' that it detects temporary links and therefore disables the survey features? I can create the survey itself via onedrive (new->excel survey) but then when opening it the survey ribbon button does not appear
- Zhongzhong_Li
And you have removed the check-out requirement?
To remove the check-out requirement, follow these steps:
- Browse to the affected library.
- On the LIBRARY tab of the ribbon, click Library Settings.
- In the General Settings section, click Versioning settings.
- Set the Require Check Out setting to No, and then click OK.
