SharePoint Document Issues

How to Fix SharePoint Online Lists Not Displaying All Items

Kushani NimanthikaKushani Nimanthika Nov 4, 2026 869 views

Question details

A SharePoint Online modern list fails to display all list items, even though the classic view shows the complete list without issues.

Fix SharePoint Online Lists That Do Not Display All Items
Product
SharePoint Online
Device & OS
Windows
Scenario
Viewing and managing data within a SharePoint Online modern list after a potential network interruption.
Observed behavior
The modern list view does not load all items and appears stuck in an offline synchronization state, often isolated to a single machine.
Before you start

Ensure your computer has a stable internet connection, and try opening the SharePoint list in a private browsing window to rule out temporary caching errors.

Solution 1Recommended

Verify Network Connection and Refresh Synchronization

Since this issue is frequently caused by a machine losing reliable internet connectivity, changing networks can force the list to sync correctly.

SharePoint modern lists use local offline caching for performance. If the connection drops unexpectedly, the sync state may hang, preventing newer or complete items from displaying. Switching the network connection often resets this state.

1
Check Windows connection status

Verify that your Windows network settings report an active and stable Internet connection.

2
Switch to another network

Disconnect from your current Wi-Fi or Ethernet and connect to a different network or mobile hotspot to force a connection reset.

3
Refresh the SharePoint list

Return to your web browser and reload the modern list page to allow SharePoint to synchronize the missing items.

Verify Network Connection and Refresh Synchronization
Network Sync Re-established: Once the list syncs successfully on the new network, you can safely switch back to your original network connection.
Free Microsoft Office alternative

Try WPS Office for Seamless Document Management and Collaboration

While resolving SharePoint and Office 365 syncing issues, consider using WPS Office as a free, lightweight alternative for your daily document creation and collaboration needs. It offers a familiar interface, built-in cloud storage, and requires no complicated setup.

  1. 1. Download the software: Visit the official WPS Office website to download the free installation package for your operating system.
  2. 2. Install and launch: Run the installer, follow the on-screen instructions, and open WPS Office.
  3. 3. Open your files: Drag and drop your existing Microsoft Office files directly into the application to continue working instantly.
Fully compatible with Microsoft Word, Excel, and PowerPoint file formats.Free, lightweight, and fast to launch on Windows, Mac, and mobile devices.Built-in cloud storage for seamless document synchronization without complex offline caching issues.Familiar user interface requiring zero learning curve for Office users.
microsoft office alternative - wps office

Frequently Asked Questions

Why does the classic view show all list items while the modern view does not?

The modern view relies on local offline caching to improve performance and allow offline editing. If the local synchronization state hangs due to a dropped internet connection, the modern view may fail to update. The classic view bypasses this cache and fetches data directly from the SharePoint server.

Could custom column formatting cause items to disappear in the modern view?

Yes. Incorrectly configured JSON column formatting can sometimes hide items or cause rendering errors specifically in modern lists. If you suspect this is the cause, try temporarily removing the formatting from the column settings to see if the missing items reappear.

Will clearing my browser cache resolve the list sync issue?

Clearing the browser cache or opening the list in an incognito/private window can sometimes force the browser to fetch the latest list items and reset broken session data, resolving display discrepancies between modern and classic views.