Others

How to Fix Disabled Edit Responses Option in Microsoft Forms

Emma Brown Sep 28, 2026 869 views

Question details

The user is unable to enable the setting that allows respondents to edit their submitted answers on an existing Microsoft Form.

How to Fix Disabled Edit Responses Option in Microsoft Forms

Product: Microsoft Forms
Device & OS: not provided
Scenario: Managing an existing Microsoft Form that has accumulated many responses and is linked to spreadsheet calculations.
Observed behavior: The 'Allow users to edit their responses' option is disabled or grayed out in the form settings, preventing respondents from modifying their submissions.

Before you start

Before proceeding, ensure you have exported your current form responses to an Excel workbook, as resolving this issue may require creating a completely new form.

Solution 1Recommended

Recreate the Form Directly in forms.office.com

This feature is exclusively available for forms created directly from the Microsoft Forms web portal, rather than forms generated through OneDrive, Excel Online, or Microsoft Teams.

Microsoft intentionally restricts the 'Allow respondents to edit their responses' feature based on how the form was originally created. If your form was initiated from Excel Online, Teams, or a OneDrive folder, the editing feature will be permanently disabled.

To resolve this, you must recreate the form using the primary Microsoft Forms dashboard.

Navigate to the Microsoft Forms portal

Open your web browser, go directly to forms.office.com, and sign in with your Microsoft 365 account credentials.

Create a new form

Click on the 'New Form' or 'New Quiz' button at the top of your dashboard to start building a fresh form. Do not copy an existing form from OneDrive.

Enable the edit setting

Once your questions are added, click the three-dot menu (More form settings) in the top right corner, select 'Settings', and check the box for 'Allow respondents to edit their responses'.

Recreate the Form Directly in forms.office.com

Data Consolidation: Since you cannot migrate this specific setting to an older form, you will need to share the new form link with your users and manually merge the old spreadsheet data with the new spreadsheet data in Excel.

Free Microsoft Office alternative

Analyze Your Form Data with WPS Office

If you are downloading Microsoft Forms responses to consolidate data from old and new forms, WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Excel for analyzing your spreadsheets.

1. Download your form responses: In Microsoft Forms, navigate to the 'Responses' tab and click 'Open in Excel' to download your collected data as an .xlsx file.
2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded .xlsx file to safely view and edit your form submissions.
3. Merge and analyze data: Use WPS Spreadsheet's powerful VLOOKUP formulas, data filtering, and formatting tools to merge responses from your old and newly recreated forms.

Fully compatible with Microsoft Excel (.xlsx and .xls) formats.Consolidate form responses easily with advanced pivot tables and built-in formulas.Lightweight installation that runs quickly even on older computers.Familiar spreadsheet interface that requires zero learning curve for Excel users.

Frequently Asked Questions

Can I enable response editing on a Microsoft Form created in Teams?

No. Forms created from within Microsoft Teams, Excel Online, or OneDrive do not support the option to allow users to edit their responses. You must create the form directly on forms.office.com.

Does Microsoft Forms allow anonymous users to edit their responses?

No. The option to edit responses is only available for forms restricted to 'Only people in my organization can respond' or 'Specific people in my organization can respond'. Anonymous users cannot retrieve or edit their submissions.

Will my linked spreadsheet update if a user edits their response?

Yes. If the form was created correctly on forms.office.com and a user modifies their submitted response, the linked spreadsheet will automatically update to reflect their latest changes.

Office Quick Solutions