Others

How to Handle Microsoft Forms Response Limits After 1,000 Submissions

Nimra Malik Oct 1, 2026 869 views

Question details

The user's Microsoft Form stopped accepting new submissions and displays a limit exceeded message after receiving 1,000 registrations.

How to Handle Microsoft Forms Response Limits After 1,000 Submissions

Product: Microsoft Forms
Device & OS: not provided
Scenario: Collecting user registrations or survey submissions via a shared Microsoft Form link.
Observed behavior: The form stops accepting new entries and shows a 'Limit exceeded for new registrations' error message once it hits 1,000 responses.

Before you start

Ensure you are logged into your Microsoft account with owner permissions for the affected form before attempting to export data or adjust the form's settings.

Solution 1Recommended

Export Existing Responses and Duplicate the Form

When a form reaches its maximum response limit, the most reliable workaround is to back up your current data and create a fresh copy of the form for new submissions.

Microsoft Forms enforces hard limits on responses based on your account type. Once that limit is reached, you cannot simply increase it. Duplicating the form provides a new link with a reset response counter.

Open Microsoft Forms

Navigate to the Microsoft Forms dashboard and click on the form that has reached its response limit.

Export Data to Excel

Go to the 'Responses' tab and click the 'Open in Excel' button to download and back up your current 1,000 responses safely.

Copy the Form

Return to the main Forms dashboard, locate your form, click the three-dot menu (...) on the form tile, and select 'Copy'.

Share the New Form

Rename the newly copied form if necessary, and share the new link with your audience to continue collecting registrations from zero.

Export Existing Responses and Duplicate the Form

Data Safety: Exporting your data ensures you have a permanent offline record before making changes or distributing a new link.

Solution 2

Clear Existing Responses

If you do not want to distribute a new link, you can delete old responses to free up space, provided you have securely backed them up first.

Solution 3

Verify Form Options and Group Limits

Sometimes a form stops accepting responses because of an artificial end date or a specific group restriction rather than the platform's absolute maximum.

Free Microsoft Office alternative

Manage Your Exported Form Data with WPS Office

While you cannot bypass Microsoft Forms' built-in response limits, you can easily manage, analyze, and combine your exported Excel response data using WPS Office. It is a free, lightweight, and highly compatible alternative to Microsoft Office.

1. Download WPS Office: Install WPS Office Free on your Windows, Mac, or mobile device.
2. Open WPS Spreadsheet: Launch the application and select the Spreadsheet module from the main workspace.
3. Analyze Responses: Click 'Open' and select your downloaded Microsoft Forms Excel (.xlsx) file to easily view, filter, and analyze your collected data.

Seamlessly open and edit exported Microsoft Excel (.xlsx) response files.Free and lightweight office suite with a familiar, easy-to-use interface.Includes Writer, Spreadsheet, Presentation, and PDF tools in one single application.

microsoft office alternative - wps office

Frequently Asked Questions

What is the maximum number of responses a Microsoft Form can receive?

For personal Microsoft accounts, the limit is typically 200 responses. For Microsoft 365 Education and commercial accounts, a single form can collect up to 5,000,000 responses. However, specific form types or older configurations may encounter lower thresholds like 1,000.

Can I increase the response limit on my Microsoft Form?

No, response limits are set automatically based on your Microsoft subscription type and cannot be manually increased. You must export and clear existing data or duplicate the form to continue.

Will I lose my data if my form exceeds the response limit?

No, exceeding the limit simply prevents new users from submitting the form. All of your previously collected responses remain safe and can be exported at any time.

How do I fix the 'Limit exceeded for new registrations' error?

To resolve this, go to your form's Responses tab, click 'Open in Excel' to back up the current registrations, then click the three-dot menu and select 'Delete all responses' to reset the counter to zero.

Office Quick Solutions