SharePoint Document Issues

Fix Deleted SharePoint List Items Still Showing in Item Count

Nimra Malik Oct 10, 2026 869 views

Question details

The user deleted a large batch of items (around 1,100) from a SharePoint list, but the deleted items still show up in the total item count and when exporting the list to Excel.

How to Fix Deleted SharePoint List Items Still Appearing in the Item Count

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Deleting a massive number of items from a SharePoint list and exporting the updated list data to Excel.
Observed behavior: Even though normal list browsing shows fewer records, the backend count and Excel exports still include the deleted items, incorrectly triggering the SharePoint 5,000-item view threshold.

Before you start

Verify that the items have successfully been removed from the frontend view and check the SharePoint Recycle Bin before escalating the issue, as this requires Microsoft 365 Administrator privileges to fully resolve.

Solution 1Recommended

Open a Support Request via Microsoft 365 Admin Center

Because this issue involves backend indexing, recycle-bin retention delays, or synchronization problems, a Microsoft 365 administrator must escalate it to Microsoft support.

When a large batch of items is deleted from a SharePoint list, the frontend view may update immediately, but the backend indexing and counting mechanisms can sometimes lag or fail to sync. This discrepancy causes exported Excel files to retain deleted rows and can artificially inflate the count over the 5,000-item threshold limit.

Since this is an environment-level synchronization or index retention issue, standard users cannot resolve it directly from the SharePoint interface. It requires an administrator to request a backend inspection from Microsoft.

Gather necessary list details

Collect all relevant information including the affected SharePoint list URL, the exact time the deletions took place, the expected vs. current item counts, and any affected Power Automate flows.

Access the Microsoft 365 Admin Center

Ask your organization's Microsoft 365 administrator to log in to the Microsoft 365 Admin portal using their admin credentials.

Create a new service request

Navigate to the Support section in the admin center and click on 'New service request'. Provide the business support team with the gathered details so they can inspect indexing and recycle-bin retention on the server side.

Open a Support Request via Microsoft 365 Admin Center

Required Information: Providing exact export results, screenshots of the discrepancy, and the timeline of the deletion will significantly speed up the troubleshooting process with Microsoft Support.

Free Microsoft Office alternative

Manage Your Exported Spreadsheets with WPS Office

While you wait for Microsoft support to resolve your SharePoint synchronization issues, try WPS Office for opening, reviewing, and editing your exported Excel lists. It is a free, lightweight, and highly compatible alternative for all your spreadsheet, document, and presentation needs.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite installer.
2. Install the software: Follow the simple on-screen installation prompts to set up WPS Office on your computer.
3. Open your SharePoint Excel exports: Launch WPS Spreadsheets and open your downloaded SharePoint .xlsx files to review, filter, or clean up your list data effortlessly.

Fully compatible with Microsoft Excel (.xlsx) formats and SharePoint exports.Lightweight installation with fast loading times for large data lists over 5,000 items.Familiar tabbed interface ensuring a seamless transition and zero learning curve.Free to download and use for your daily office spreadsheet tasks.

Frequently Asked Questions

Why do deleted SharePoint list items still show up in my Excel export?

This usually occurs due to backend caching delays, synchronization issues, or items being retained in the SharePoint Recycle Bin before the search index fully updates to reflect the deletions.

How does an incorrect item count affect the SharePoint 5,000-item threshold?

If the backend system still registers the deleted items, it calculates the total list view size as being over 5,000 items. This triggers SharePoint's view limit restriction, blocking standard filtering and sorting operations even if the visible count is lower.

Will emptying the SharePoint Recycle Bin fix the list count issue?

In some instances, permanently deleting the items from both the first-stage (site) and second-stage (site collection) Recycle Bins forces an update to the storage metrics and item counts. However, if the index is stuck, administrative intervention is still required.

Document & File Issues