How to Fix Access Denied When Downloading Microsoft Forms Responses to Excel
Question details
A Microsoft Forms collaborator is unable to download the linked Excel workbook containing form responses despite having access to view the form online.
- Product
- Microsoft Forms / Excel
- Device & OS
- not provided
- Scenario
- Collaborating on Microsoft Forms and attempting to export or download the response data into an Excel spreadsheet.
- Observed behavior
- The user can view the responses on the Microsoft Forms interface but receives an "Access Denied" error when trying to download the linked Excel workbook.
Verify whether the Microsoft Form was created as a personal form (stored in OneDrive) or a group form (stored in SharePoint), as this determines where the Excel file is saved and how its permissions are managed.
Grant Direct Access to the Linked Excel Workbook
Collaborator permissions on Forms do not automatically carry over to the underlying Excel file in OneDrive or SharePoint. The file owner must share the workbook directly.
Microsoft Forms handles form-editing permissions separately from the file permissions of the linked Excel spreadsheet. To fix the "Access Denied" error, the owner must locate the source workbook and grant explicit file-level access.
The form owner should log into their Microsoft 365 account and open the OneDrive or SharePoint folder where the response workbook is stored.
Right-click the Excel workbook and select 'Share' or 'Manage Access' from the context menu.
Enter the collaborator's email address and ensure they are granted at least 'View' permissions.
Click 'Send' or copy the direct link and provide it to the collaborator, allowing them to download the file directly.
Verify SharePoint Folder and Organizational Policies
Inherited folder permissions, antivirus settings, or strict organizational sharing policies might block access even if the specific file is shared.
Edit Your Exported Data with WPS Office
Once you have successfully resolved the permission issues and downloaded your form responses, you can easily open, analyze, and edit the Excel workbook using WPS Office. It provides a highly compatible, free alternative to Microsoft Office.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite to your computer.
- 2. Install and Launch: Follow the straightforward installation prompts, then open the WPS Spreadsheets application.
- 3. Open the Response File: Click 'Open' and select your downloaded Microsoft Forms Excel workbook to start analyzing the data immediately.
Frequently Asked Questions
Why can I view Microsoft Form responses online but not download the Excel file?
Viewing responses in the Forms web interface relies on form collaboration permissions. However, downloading the Excel file requires direct file-level read permissions for the specific workbook stored in the owner's OneDrive or SharePoint.
Where is the Microsoft Forms Excel response workbook stored?
For personal forms, the workbook is stored in the creator's OneDrive for Business. For group forms, it is located in the document library of the corresponding SharePoint team site.
Can a collaborator create a new Excel response workbook?
No, only the form owner or an administrator with full control can unlink the current workbook and generate a new Excel response file.
How do I change the owner of a Microsoft Form to fix access issues?
A global administrator or the original owner can move a personal form to a Microsoft 365 Group. This action automatically transfers ownership and stores the associated Excel file in the group's SharePoint site, making it accessible to all group members.
