Permission & Access Issues

Fix "You Don't Have Access" When Opening Microsoft Forms Results in Excel

Adam Davis Oct 9, 2026 869 views

Question details

Users encounter a "Sorry, you don't have access" error message when attempting to export or open Microsoft Forms response results in a linked Excel workbook.

How to Fix "You Don't Have Access" When Opening Microsoft Forms Results in Excel

Product: Microsoft Forms and Excel
Device & OS: not provided
Scenario: Attempting to view Microsoft Forms survey or quiz responses by opening the linked Excel workbook.
Observed behavior: The system displays an access denied error message instead of opening the Excel file containing the form responses.

Before you start

Ensure you have a stable internet connection and verify that you are currently signed into the exact Microsoft account associated with the original form.

Solution 1Recommended

Use Incognito or Private Browsing Mode

Opening the form in a private window bypasses browser cache and conflicting account sessions, which is the most common cause of access errors.

Browser session conflicts frequently occur if you have logged into multiple personal, school, or work Microsoft accounts on the same device. Private browsing forces a fresh login session.

Launch a private window

Open your web browser and launch a new Private or Incognito window (press Ctrl+Shift+N in Chrome/Edge, or Ctrl+Shift+P in Firefox).

Sign into Microsoft Forms

Navigate to the Microsoft Forms website and sign in using the specific Microsoft account that created or has authorized access to the form.

Open results in Excel

Go to the 'Responses' tab of your form and click the 'Open in Excel' button to verify if the file now opens successfully.

Solution 2

Verify Ownership and Workbook Permissions

Ensure you have the necessary access rights to the destination Excel file, especially if it is stored in a shared SharePoint or OneDrive folder.

Solution 3

Test File Isolation with a New Form

Determine if the access issue is widespread across your account or isolated to a single corrupted form.

Free Microsoft Office alternative

View and Edit Your Form Data Seamlessly with WPS Office

If you're experiencing ongoing access issues or subscription problems with Microsoft Excel online, consider downloading your form responses as a local file and opening them securely in WPS Office. It is a highly compatible, free, and lightweight alternative to Microsoft Office.

1. Download form data: Save your Microsoft Forms responses to your computer as a local .xlsx or .csv file.
2. Open in WPS Spreadsheet: Right-click the downloaded file, select 'Open with', and choose WPS Office to view and analyze your survey data instantly.

100% compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsLightweight application that runs smoothly on Windows, Mac, Linux, and mobileFamiliar user interface ensuring zero learning curve for Excel usersFree to use for everyday spreadsheet and data analysis tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Forms say I don't have access to an Excel file I created?

This usually happens if you are logged into multiple Microsoft accounts in the same browser, which creates a session token conflict. It can also occur if the linked Excel file was moved, renamed, or deleted from its original OneDrive or SharePoint directory.

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

Yes. If your workbook access is permanently broken, you can sync the form data to a new file. Go to the Responses tab, click the More options icon (three dots) next to 'Open in Excel', and select 'Sync all responses to a new workbook'.

Do I need a paid Microsoft 365 subscription to open Forms responses in Excel?

You need a valid Microsoft account to use Forms. However, if the Excel file is stored on an enterprise SharePoint or business OneDrive, you must have an active organizational license and the proper directory permissions to access it.

How do I share Microsoft Forms results without giving full Excel file access?

Instead of sharing the direct Excel workbook, you can share a visual summary link. Navigate to the Responses tab, click 'More options' (three dots), and select 'Get a summary link' to securely share visual charts with others without granting file-level access.

Document & File Issues