Permission & Access Issues

How to Fix Cannot Open Excel Workbook Linked to Microsoft Forms

Olivia MillerOlivia Miller Oct 23, 2026 869 views

Question details

Users are unable to access the Excel workbook associated with a Microsoft Form due to missing permissions or untracked access requests.

Fix: Cannot Open Excel Workbook Linked to Microsoft Forms
Product
Microsoft Excel / Microsoft Forms
Device & OS
not provided
Scenario
A user attempts to view Microsoft Forms responses by clicking 'Open in Excel' but encounters an error or access prompt.
Observed behavior
The 'Open in Excel' option is blocked, and the form owner cannot find where to approve the generated access request.
Before you start

Ensure you are logged in with the correct Microsoft 365 organizational account and record any specific error codes provided when the opening fails.

Solution 1Recommended

Review and Grant Workbook Sharing Permissions

The form owner must verify the sharing settings in OneDrive or SharePoint to ensure users have the necessary access to the underlying Excel workbook.

Microsoft Forms often stores the linked Excel workbook in the creator's OneDrive for Business or a shared SharePoint document library. Accessing the form does not automatically grant access to the spreadsheet.

1
Locate the Excel file

Sign in to Microsoft 365, open OneDrive or SharePoint, and find the specific Excel workbook tied to your form.

2
Open Manage Access

Right-click the Excel workbook and select 'Manage Access' from the context menu.

3
Approve pending requests

Check the 'Requests' tab to approve any pending access requests from users trying to open the workbook.

4
Grant direct access

If no requests are visible, click the '+' icon next to 'Direct Access' to manually add the email addresses of the required users.

SharePoint Access Requests: If the workbook is stored on a SharePoint site, access requests might be routed to the site admin. Check 'Site Settings' > 'Access requests and invitations'.
Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you frequently encounter complex permission glitches and access request loops with Microsoft Office, consider switching to WPS Office. It provides a lightweight, free alternative for viewing, editing, and sharing Excel files without complex access barriers.

  1. 1. Download and install: Get WPS Office from the official website and complete the quick installation.
  2. 2. Export form data: If you cannot link the file directly, export your form responses as a standard .csv or .xlsx file.
  3. 3. Open instantly in WPS: Double-click the downloaded file to instantly open and analyze your data in WPS Spreadsheets with full formatting support.
Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Built-in WPS Forms for easy data collection and direct spreadsheet integration.Lightweight software that runs smoothly on Windows, Mac, and Linux.Familiar user interface with zero learning curve for Excel users.
microsoft office alternative - wps office

Frequently Asked Questions

Why is the 'Open in Excel' button missing or grayed out in Microsoft Forms?

This typically occurs if the original workbook was deleted, moved, or corrupted from its source location (OneDrive or SharePoint). It can also happen if the form was created in a Group and you lack the necessary SharePoint permissions.

Can I unlink and relink a new Excel workbook to my Microsoft Form?

Yes. If the original link is broken, navigate to the 'Responses' tab of your Form, click the three-dot menu, and select 'Sync all responses to a new workbook' to create a fresh connection.

Does anyone who can fill out the form automatically get access to the Excel workbook?

No. Filling out the form and viewing the results spreadsheet are managed by two separate permission layers. The form owner must explicitly share the Excel workbook with users who need to view the raw data.