SharePoint Document Issues

Fix SharePoint List Items Missing in View but Showing in Excel Export

Aamir Naveed Akram Oct 13, 2026 870 views

Question details

Users are unable to see certain items in a SharePoint list view, but these hidden items become visible when the list is exported to Microsoft Excel.

Fix SharePoint List Items Missing in View but Showing in Excel

Product: SharePoint Server 2016 / Microsoft Excel
Device & OS: not provided
Scenario: Viewing and exporting list items from SharePoint Server 2016 to Excel.
Observed behavior: Some items are missing from the configured SharePoint list view but appear in the resulting Excel file after export, often involving items with a different URL pattern.

Before you start

Ensure you have the appropriate site permissions to edit list views and view all items, including items pending content approval or those with unique item-level permissions.

Solution 1Recommended

Review and Clear List View Filters and Limits

Check if the list view has active filters, grouping configurations, or item limits that are hiding specific entries in the web UI.

SharePoint allows administrators to set complex filters and display limits on list views. Often, items are not truly missing; they are simply being filtered out by the view settings, whereas the Excel export pulls the broader dataset.

Navigate to view settings

Open the problematic SharePoint list, click on the 'List' tab in the top ribbon, and select 'Modify View'.

Check the Filter section

Scroll down to the 'Filter' section and verify if there are any active conditions (e.g., 'Show items only when the following is true') that might exclude items with different URL patterns.

Verify item limits

Expand the 'Item Limit' section and ensure the display limit is not artificially restricting the number of items shown on the page.

Save and refresh

Remove any unintended filters, increase the item limit if necessary, click 'OK' to save the view, and refresh the page to see if the missing items appear.

Review and Clear List View Filters and Limits

Content Approval Settings: Also check if 'Require content approval for submitted items' is turned on in List Settings. Unapproved draft items might not show up in public views.

Solution 2

Create a New Standard View without Filters

Creating a completely new view helps determine if the current view is corrupted or misconfigured.

Solution 3

Consult Microsoft Q&A for Complex Server Issues

If view settings are correct, the issue might stem from deep server or permission configurations specific to SharePoint 2016.

Free Microsoft Office alternative

Use WPS Office for Seamless Excel and Spreadsheet Management

While SharePoint server view configurations require Microsoft-specific troubleshooting, managing your exported list data is effortless with WPS Office. WPS Spreadsheet is a free, lightweight, and highly compatible alternative to Microsoft Excel.

1. Export from SharePoint: Use the 'Export to Excel' function in your SharePoint list to generate a downloadable data file.
2. Download WPS Office: Install the free WPS Office suite on your computer.
3. Analyze your data: Open the exported file using WPS Spreadsheet to view, filter, and analyze your complete list data without missing items.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight design ensures fast opening of large exported SharePoint datasets.Familiar user interface requires no learning curve.Free built-in tools for advanced data filtering, sorting, and pivot tables.

microsoft office alternative - wps office

Frequently Asked Questions

Why do items appear in Excel but not in SharePoint?

This usually happens because Excel exports the raw dataset based on the underlying query, bypassing view-specific display limits, grouping constraints, or visual web part filters applied in the SharePoint UI.

Can item-level permissions hide items in a SharePoint list view?

Yes. If a user lacks read permissions for specific items, those items will not render in the list view. However, if the Excel export is executed under elevated credentials or pulling differently cached data, it might retrieve more items than the UI displays.

How do content approval settings affect list visibility?

If content approval is enabled, items in 'Draft' or 'Pending' status may only be visible to their creators or users with full approval rights. Standard users viewing the list will not see these items until they are officially approved.

How can I check if URL patterns are causing SharePoint items to disappear?

Items with extremely long URLs or special characters might fail to render properly in standard web views due to path length limitations in SharePoint 2016. Exporting them to Excel bypasses the web UI rendering, which is often why they still appear in the spreadsheet.

Document & File Issues