Others

How to Change Microsoft Forms Response Settings Without Losing Data

Muhammad Talha Oct 12, 2026 869 views

Question details

The user wants to know how to change a Microsoft Forms survey from organization-only to public access without losing any previously collected responses.

How to Change Microsoft Forms Response Settings Without Losing Data

Product: Microsoft Forms
Device & OS: not provided
Scenario: Modifying access permissions for an active survey or form to allow external respondents to participate.
Observed behavior: The user needs to ensure that switching to 'Anyone can respond' will keep existing data intact and maintain the functionality of the original form link.

Before you start

Ensure you are logged into the Microsoft account associated with the form and have the necessary administrative permissions to edit the form's sharing settings.

Solution 1Recommended

Change Forms Access Settings to Public

Update the response settings to allow anyone to respond while safely retaining all previous submissions.

Changing your form's access level from 'Only people in my organization can respond' to 'Anyone can respond' only affects future respondents. All existing submissions remain perfectly intact in your results tab, and the original sharing link continues to work normally.

Open your form

Navigate to Microsoft Forms in your browser and open the specific form or quiz you want to modify.

Access form settings

Click on the three dots (More form settings) located in the top right corner of the screen and select 'Settings' from the drop-down menu.

Update response permissions

Under the 'Who can fill out this form' section, click the radio button next to 'Anyone can respond'.

Share the existing link

Click the 'Collect responses' button. You can continue to use the exact same link to share with your new public audience.

Link Consistency: You do not need to generate or send out a new link to previous recipients; the existing link will automatically reflect the new public access setting.

Free Microsoft Office alternative

Try WPS Office for Your Data Analysis Needs

After collecting responses in Microsoft Forms, analyzing the exported data is the next critical step. WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office, featuring a powerful Spreadsheet tool designed to process your exported form data seamlessly.

1. Download and Install: Get WPS Office Free from the official website and install it on your device.
2. Export Form Data: In Microsoft Forms, go to the Responses tab and click 'Open in Excel' to download your collected data as an .xlsx file.
3. Analyze in WPS Spreadsheet: Open the downloaded .xlsx file in WPS Spreadsheet to filter, create charts, and analyze your survey results without any formatting loss.

Free and lightweight office suite for seamless daily tasksFully compatible with Microsoft Excel (.xlsx) for form data analysisFamiliar user interface ensuring a zero-learning-curve transitionBuilt-in robust templates for professional data reporting

microsoft office alternative - wps office

Frequently Asked Questions

Will changing the response setting to 'Anyone can respond' change my form link?

No, changing the response permissions does not alter the form's original URL. Any links you have already shared will continue to work and will automatically allow public access once the setting is saved.

Do I lose any existing responses when I change form permissions?

No, all previously collected responses are securely saved. Changing the setting only affects who is allowed to submit new responses going forward, leaving past data completely untouched.

Can I change a public form back to organization-only later?

Yes, you can revert the setting back to 'Only people in my organization can respond' at any time via the Settings menu. Existing responses from the public period will still be retained in your results.

Office Quick Solutions