How to Fix Users Cannot Submit an Excel Survey in SharePoint
Question details
Some users are unable to submit their responses to an Excel survey hosted on SharePoint, while others can submit without issues.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Users are attempting to fill out and submit a shared Excel survey linked to a SharePoint workbook.
- Observed behavior
- An error prevents certain users from successfully submitting the survey response, despite the workbook having a stable internet connection and allowing other users to submit.
Ensure that you have administrative or editing permissions for the SharePoint folder where the Excel workbook is stored, and verify that the affected users are connected to the internet.
Check Survey Settings and User Permissions
Ensure that response submission is enabled in the survey settings and that affected users have the correct access rights to the SharePoint workbook.
In many cases, survey access issues are caused by restrictive SharePoint permissions or disabled submission settings within the Forms for Excel pane.
Open the workbook containing the survey in Excel for the web or the Excel desktop application.
Navigate to the 'Insert' tab on the top ribbon and select 'Forms' to open the Forms for Excel pane.
Choose the specific survey you want to configure, click on 'Settings', and confirm that the option to accept responses is enabled.
Check your SharePoint sharing settings to ensure that the affected users have appropriate access permissions to both the workbook and the survey link.
Address Invalid Responses and File Compatibility
Check for incompatible file formats or invalid data entries that might trigger submission errors.
Try WPS Office for Seamless Data Collection and Spreadsheets
If you are experiencing persistent issues with Microsoft Excel surveys and complex SharePoint permissions, consider switching to WPS Office. It provides a highly compatible, free alternative with powerful spreadsheet tools and built-in form features for effortless data collection.
- 1. Download WPS Office: Visit the official WPS website to download and install WPS Office for free on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and easily open your existing .xlsx workbooks.
- 3. Create a WPS Form: Navigate to the Tools tab and select WPS Form to instantly create a new survey and generate a highly accessible sharing link.
Frequently Asked Questions
Why can only some users submit the Excel survey while others cannot?
This usually happens when specific users lack the necessary SharePoint access permissions, are not logged into a supported Microsoft account, or are using an incompatible browser that blocks the form scripts.
Where do I find the Forms settings in my Excel workbook?
Open your workbook in Excel for the web or desktop, go to the 'Insert' tab, click 'Forms', and open the 'Forms for Excel' pane to access and modify your survey settings.
Does the survey work if the Excel file is not hosted on SharePoint?
No, Excel surveys and Forms for Excel typically require the workbook to be securely stored and synced on OneDrive for Business or SharePoint to collect responses in real-time.
