OneDrive File Issues

Fix Microsoft Forms Open in Excel OneDrive Access Errors

Maira Mehtab Sep 22, 2026 868 views

Question details

The user is unable to open form responses in Excel from Microsoft Forms due to a OneDrive access error prompting for administrator permission.

Product: Microsoft Forms and Excel Online
Device & OS: not provided
Scenario: Attempting to view Microsoft Forms responses by selecting the "Open in Excel" option.
Observed behavior: An error message appears stating that Excel Online could not open the workbook and that an administrator must provide OneDrive access.

Before you start

Ensure you have your Microsoft 365 account credentials ready, and verify that you are logging into the exact tenant where the original form was created.

Solution 1Recommended

Verify OneDrive Provisioning and Form Ownership

Microsoft Forms saves response workbooks directly to the form owner's personal OneDrive. Ensuring your OneDrive is active and matches the form's tenant is the most direct fix.

When you create a form and click 'Open in Excel', the system attempts to create or access a live-syncing workbook within your OneDrive. If your OneDrive has not been provisioned by your IT department, or if you are logged into a different account, Excel Online will fail to access the file.

Sign in to your Microsoft 365 Account

Go to office.com and log in using the exact account and tenant that owns the Microsoft Form.

Access the OneDrive App directly

From the Microsoft 365 app launcher (the waffle icon in the top left), select OneDrive. Wait for it to load to ensure your personal storage is fully provisioned and accessible.

Retry opening the form responses

Navigate back to Microsoft Forms, open your specific form, go to the Responses tab, and select 'Open in Excel' again.

Contact your IT Administrator

If OneDrive fails to load in step 2 or displays an access denied message, contact your Microsoft 365 administrator to grant you the proper OneDrive license and access permissions.

Collaborator Limitations: If you are only a collaborator on the form and not the owner, the original creator must have an active, provisioned OneDrive for the live Excel workbook to function correctly.

Free Microsoft Office alternative

Analyze Your Form Responses Offline with WPS Office

If cloud access issues with Excel Online and OneDrive are preventing you from viewing your data, you can download a static copy of your responses and analyze them locally using WPS Office. It provides a lightweight, highly compatible, and completely free alternative to Microsoft Office.

1. Download your responses: If your form settings permit, download the static CSV or Excel file of your responses directly to your local computer.
2. Open WPS Office: Launch WPS Office on your device and click on 'Spreadsheets' from the main dashboard.
3. Analyze your data: Open the downloaded form responses workbook to view, filter, and analyze your data safely offline.

Fully compatible with Microsoft Excel file formats (.xlsx, .xls, .csv).Works completely offline without requiring cloud storage provisioning.Free and lightweight alternative to Microsoft 365.Familiar spreadsheet interface requires zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Forms require OneDrive to open responses in Excel?

When you create a form in Microsoft 365, clicking "Open in Excel" creates a live-syncing workbook stored in the form creator's personal OneDrive (or SharePoint for group forms) to collect and update responses in real time.

How do I check if my Microsoft 365 OneDrive is provisioned?

Log in to the Microsoft 365 web portal and click the OneDrive icon from the app menu. If you can view your folders and successfully upload a new document, your OneDrive is fully provisioned and accessible.

Can I open the responses if I am not the form owner?

If a form was shared with you but you are not the primary owner, you can only view the live Excel workbook if the original creator's OneDrive is active and they have granted you the proper file sharing permissions.

Document & File Issues