Enable easy creation of surveys for OneDrive for Business/SharePoint authenticated users without compromising security
Now by default a user of OneDrive for Business/SharePoint simply cannot create a survey. Even if it is intended for other authenticated users only (without enabling anonymous guest links).
Now a survey can be created only if anonymous guest access is enabled at the site collection level by the admin. However, that is usually restricted by corporate security policies. More detailed explanation by this link: http://corypeters.net/2013/08/enabling-excel-survey-in-team-sites/
This is a major hindrance for the O365 Survey functionality adoption by O365 OneDrive for Business/SP Online users.
Please enable creation of Excel surveys for internal/authorized purposes.
Specifically, when the default "Don't allow sharing outside your organization" or "Allow external users who accept sharing invitations and sign in as authenticated users" options are set in the OneDrive for Business/SharePoint setup.
We update the experience of Excel Survey with a new experience. Excel Survey will be powered by Microsoft Forms and will be renamed “Forms for Excel”. This update comes with a modern experience to make it simple and easy to collect information into Excel in real-time, with all Microsoft Forms features.
The new “Forms for Excel” can be used without changing the organization’s sharing settings in OneDrive. You could get more detail form – https://aka.ms/formsforexcel
It would be great if you could provide feedback for us – https://aka.ms/excelsurveyfeedback
Finally, some help from MS! :) Thanks!
Can't wait to try the new Forms for Excel then.
We have been waiting this for a looooong time. No help from MS - as usual!
Where is Microsoft's response to this point!?
Just to chime in; Office 365 for Education has a fantastic survey product. Why are businesses left out in the cold, I would think the education sector is just as onerous when it comes to security and discover. Not to mention... Excel Surveys wont even resize correctly on an iPhone 7.
Because of this limitation, I could not find a suitable solution in either OneDrive or SharePoint leveraging MS experts to guide me. I quite literally now have multiple departments using Google Apps and a Google Form specifically for this survey task. It's absurd. Please implement or fix this functionality Microsoft!
I cannot believe that this is still an issue.
Something simple like this should be possible!
Sometimes I'm wondering what drugs the guys at Microsoft are using when they make such decisions?
Actually anonymous guest links need to be enabled for the entire tenant, as well as at the site collection level. What our organization did was to create a site collection specifically only for use in creating Excel surveys, and turn off anonymous guest links for all other site collections. I'll also require an expiry date for all shared links. Hard to police, I know, but it's better than nothing. I'd like to see a setting in Sharepoint to require an expiry date and specify a maximum lifetime. My two cents.
Microsoft, please correct this situation so we can use Excel Surveys without security issues!
Derek Deeg commented
I’d like to reiterate this!
Our organization would LOVE to permit INTERNAL-ONLY Excel Surveys WITHOUT the requirement to turn on ‘External Sharing’ in our Office 365 tenant.
We understand that the only solution to enable Office 365 Excel Surveys (as per the Office 365 community and KB article) is to enable External sharing.
Our Office 365 tenant is currently configured as ‘Don’t allow sharing outside your organization’ due to security concerns and the current absence of Information Rights Management capabilities on OneDrive for Business Libraries.
Please consider this request! We’d love to start using Excel Survey’s in our organization.
Adrian Hyde commented
Currently many large organizations do not allow external sharing from their O365 tenant for various reasons. However these same companies would like to use the Excel survey feature within their own organization.
The current limitation of only allowing anonymous surveys is blocking the use of surveys in many of these companies.