How to Fix a Blank 'Show All' Page in SharePoint Lists
Question details
The user encounters a completely blank page when attempting to expand a SharePoint list grouped view by clicking the 'Show All' button.
- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Expanding a grouped view in a SharePoint list to load more than the initial 30 items.
- Observed behavior
- Instead of loading the remaining list items, clicking the 'Show All' button causes the web page to turn completely blank.
Ensure you have a stable internet connection and check if this blank page issue occurs in multiple SharePoint lists or just one specific list.
Test with an InPrivate Window or Different Browser
Rule out browser cache issues or extension conflicts that might prevent SharePoint lists from rendering correctly.
Sometimes, cached data or browser extensions interfere with SharePoint's modern page scripts, resulting in a blank page when loading additional list items.
Launch your web browser and open a new InPrivate or Incognito window.
Log in to your SharePoint account and navigate to the list with the grouped view.
Expand the group and select the 'Show All' button to see if the remaining results load correctly.
If the list loads successfully in the private window, clear your standard browser's cache and cookies, or try using an entirely different web browser.
Switch to Classic SharePoint Experience
Revert to the classic interface to bypass rendering issues specific to the modern SharePoint experience.
Need to Edit Exported SharePoint Lists? Try WPS Office
If SharePoint's web interface is acting up, exporting your list to a spreadsheet is a great workaround. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, making it incredibly easy to open and manage your exported list data without unexpected glitches.
- 1. Download WPS Office: Visit the official WPS Office website and download the free software for your device.
- 2. Export Your List: In SharePoint, use the 'Export to Excel' or 'Export to CSV' button from the top command bar.
- 3. Open with WPS Spreadsheet: Open the exported file effortlessly in WPS Spreadsheet to view, filter, and edit all your list items without page errors.
Frequently Asked Questions
Why does a grouped view in SharePoint only show 30 items initially?
By default, SharePoint limits grouped views to displaying 30 items per group initially. This is a design choice to optimize page loading speeds and performance. You must click 'Show All' to load additional items within a specific group.
How can I view my SharePoint list if the 'Show All' button is completely broken?
If expanding groups continually causes a blank page, you can temporarily bypass this by selecting 'Export' from the top command bar to download the entire list as an Excel or CSV file for local offline viewing.
Will clearing my browser cache fix the blank page issue in SharePoint?
Yes, clearing your browser's cache and cookies often resolves unexpected blank pages. It forces the browser to discard old temporary files and fetch fresh, uncorrupted page scripts directly from the SharePoint server.
