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...
Zhongzhong_Li
Microsoft
MicrosoftAnd 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.
It regards a personal onedrive, not a library. The reason being that we cannot allow anonymous editing/sharing on sharepoint. The security risk is to big.
Current we only allow anonymous access (read-only), would that be the case? It just to work fine a few weeks ago (no changes made to the tenant whatsoever).
Could there be changes regarding this on microsoft side? (since others report the same issue)
Current we only allow anonymous access (read-only), would that be the case? It just to work fine a few weeks ago (no changes made to the tenant whatsoever).
Could there be changes regarding this on microsoft side? (since others report the same issue)
- Zhongzhong_Li
OneDrive team build new features to provide more controls for IT admin on “anonymous access link”– It is an improvement for Admin based on feedback. Before, Admin has to grant both “view” and “edit” permission, but now, they could just enable “view” to manage the risk.
However, once they set "view" to "anonymous access link", they will lose Excel survey feature.
- Is this something that was changed recently though? Before people weren't reporting this, now they are... a bit weird.
- Thanks for your quick answer. I will inform the people working with this functionality and see if they can be asked to use a non-anonymous workaround (such as Sharepoint App 'survey' list)
- Zhongzhong_LiThe current implementation of Excel survey requires "edit" permission, as I mentioned before, all the responders are actually co-authors to submit new rows to the same Excel workbook. Yes, I understand your scenarios and pain point. We are working on the new infra and removing the dependency for "anonymous access link" is the top item. Thanks, Zhongzhong