No Excel survey option when you click +new in a SharePoint Online library

PROBLEM
When you click +new in a SharePoint Online library, and then you view the list of available options in the Create a new file dialog box, the Excel survey option isn't available.
SOLUTION
To make the Excel survey option available, the following settings must be configured:
  • You must enable external sharing for your organization.
  • The library must have file check-out disabled.


To enable external sharing, follow these steps:
  1. Sign in to the SharePoint admin center.
  2. Select the check box next to the affected site collection.
  3. On the ribbon, click the Sharing button.
  4. Click the Allow sharing with all external users, and by using anonymous access links option, and then click Save.
Note If you receive the "Sharing is disabled in Tenant Settings" message when you try to make this change, you must first enable sharing for the organization in the SharePoint admin center. To do this, follow these steps:
  1. Sign in to the SharePoint admin center.
  2. On the left side of the page, click settings.
  3. In the External sharing section, click the Allow sharing with all external users, and by using anonymous access links option, and then click OK.
To remove the check-out requirement, follow these steps:
  1. Browse to the affected library.
  2. On the LIBRARY tab of the ribbon, click Library Settings.
  3. In the General Settings section, click Versioning settings.
  4. Set the Require Check Out setting to No, and then click OK.
Note Check-out must be disabled because anonymous users can't check-out files and complete the survey. If your existing library requires check-out, we recommend that you create a new library specifically for Excel Survey files.
MORE INFORMATION
By design, this behavior occurs when external sharing is not enabled for a site collection.

For more information about how to manage external sharing for your SharePoint online environment, go to the following Microsoft website: For more information about document check-out, go to the following Microsoft website:

Still need help? Go to the Office 365 Community website.
Properties

Article ID: 2890031 - Last Review: 03/23/2016 20:11:00 - Revision: 8.0

Microsoft SharePoint Online

  • o365 o365e o365a o365m o365022013 KB2890031
Feedback