Others

Does Microsoft Lists Have a 30-Row Limit? How to Fix It

WPS Content Manager Sep 30, 2026 868 views

Question details

Users are experiencing an issue where Microsoft Lists stops saving new records or displaying entries after reaching approximately 30 rows.

Troubleshooting the 30-Row Limit Issue in Microsoft Lists

Product: Microsoft Lists
Device & OS: not provided
Scenario: Adding new records, editing forms, or managing list data across web browsers and mobile apps.
Observed behavior: New records fail to save, forms do not display all fields, and the list appears restricted to around 23 to 30 rows despite not reaching actual capacity.

Before you start

Before troubleshooting, ensure you have a stable internet connection and that you are logged into the correct Microsoft 365 account with full edit permissions for the list.

Solution 1Recommended

Check List Grouping and Filters

Since Microsoft Lists supports millions of items, an apparent 30-row limit is usually caused by active filters or grouping settings hiding your records.

Views in Microsoft Lists can be customized to filter out specific items or group them in ways that collapse older records. Clearing these settings will reveal if your records are actually being saved but are just hidden from view.

Clear Active Filters

Open Microsoft Lists, navigate to the top-right corner of your list view, and click the 'Filter' icon to ensure no active filters are hiding your recently added rows.

Remove Groupings

Click on the current view name (e.g., 'All Items') at the top right, select 'Edit current view', and scroll down to the 'Group By' section to remove any grouping configurations.

Save View Changes

Click 'OK' at the top or bottom of the settings page to apply your changes and refresh the list.

Check Item Limits: While in the 'Edit current view' settings, scroll to the 'Item Limit' section and ensure it is not manually set to display only 30 items per page.

Solution 2

Use the 'Edit in Grid View' Feature

Bypassing the standard input form by using grid view can resolve issues where specific fields or form configurations prevent records from saving.

Solution 3

Troubleshoot Browser and Form Configurations

If forms do not display all fields or grid view blocks date entries, browser cache or hidden mandatory fields may be the culprit.

Free Microsoft Office alternative

Track Data Seamlessly with WPS Spreadsheet

If Microsoft Lists keeps freezing or restricting your rows due to view bugs, WPS Spreadsheet offers a powerful and reliable way to track your data without unexpected saving errors. It provides a lightweight, highly compatible alternative to Microsoft Office for managing lists effortlessly.

1. Download and Install: Install WPS Office for free from the official website and open WPS Spreadsheet.
2. Migrate Your Data: Export your Microsoft List to an Excel file and open it directly in WPS Spreadsheet.
3. Manage Without Limits: Continue tracking your records smoothly without worrying about synchronization limits or form bugs.

100% compatible with Microsoft Excel (.xlsx) formats for easy data migrationNo artificial 30-row limits or complex view restrictions hiding your dataFree, lightweight, and easy to use across Windows, Mac, iOS, and Android devices

microsoft office alternative - wps office

Frequently Asked Questions

What is the actual maximum row capacity for Microsoft Lists?

Microsoft Lists can support up to 30 million items per list. A perceived limit of 30 rows is typically caused by an active view setting, a grouping error, or a temporary browser glitch rather than a system limitation.

Why won't Microsoft Lists let me enter a date in grid view?

This can happen if the column is strictly formatted or if there is a browser compatibility issue. Try switching to the standard form view, ensuring the date format exactly matches your regional settings, or using an alternative web browser.

Can required fields stop a list from saving new rows?

Yes. If your list contains a mandatory column that is either hidden from the current form view or left blank by mistake, the system will fail to save the new record. Check your List Settings to verify which columns are marked as required.

Office Quick Solutions