How to Fix SharePoint Online Lists Not Displaying All Items
Question details
A SharePoint Online modern list fails to display all list items, even though the classic view shows the complete list without issues.

- 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.
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.
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.
Verify that your Windows network settings report an active and stable Internet connection.
Disconnect from your current Wi-Fi or Ethernet and connect to a different network or mobile hotspot to force a connection reset.
Return to your web browser and reload the modern list page to allow SharePoint to synchronize the missing items.

Disable Offline Client Availability
If you do not require offline access to this specific list, disabling the offline client availability prevents the modern view from hanging on sync states.
Temporarily Switch to Classic SharePoint View
As a temporary workaround, you can use the classic experience, which loads data directly from the server rather than relying on local caching.
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. Download the software: Visit the official WPS Office website to download the free installation package for your operating system.
- 2. Install and launch: Run the installer, follow the on-screen instructions, and open WPS Office.
- 3. Open your files: Drag and drop your existing Microsoft Office files directly into the application to continue working instantly.

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.




