Others

Fix SharePoint Storage Showing Different Totals in Active Sites and Metrics

Maira Mehtab Sep 20, 2026 869 views

Question details

Users are experiencing a mismatch in reported storage totals between the Active Sites view and the Storage Metrics report.

Product: SharePoint Online
Device & OS: not provided
Scenario: Reviewing site storage capacity and investigating consumption reports after cleanups.
Observed behavior: Active Sites displays a significantly higher storage total (e.g., 1.8 TB) compared to Storage Metrics (e.g., 903 GB), even after emptying recycle bins and verifying retention policies.

Before you start

SharePoint Online storage reporting is not real-time; allow up to 24-48 hours for backend synchronization to reflect recent deletions before assuming there is a persistent error.

Solution 1Recommended

Wait for Synchronization and Review File Version History

Hidden storage consumption often comes from delayed synchronization or multiple file versions that are not immediately obvious in standard metric views.

SharePoint aggregates storage metrics using scheduled backend timer jobs. A massive cleanup won't immediately update the Active Sites storage total.

Additionally, excessive file versioning can consume massive amounts of hidden quota.

Wait 24 Hours

Allow at least 24 hours to pass after deleting files or clearing the recycle bin to ensure Microsoft's backend jobs have fully synchronized the storage metrics.

Navigate to Document Library

Open your SharePoint site and navigate to the specific Document Libraries where your largest files are stored.

Check Version History

Click the ellipsis (...) next to heavily edited files, select 'Version history', and compare the cumulative size of all versions against your expected storage totals.

Solution 2

Verify Actual Usage Using PowerShell

Use SharePoint Online PowerShell to fetch the most accurate and current storage usage directly from the backend server.

Solution 3

Contact Microsoft Support for Orphaned Data

If delays and hidden data do not explain the discrepancy, backend indexing issues or orphaned data may require Microsoft's intervention.

Free Microsoft Office alternative

Manage Your Documents Efficiently with WPS Office

While resolving backend SharePoint storage discrepancies requires Microsoft support, managing your daily documents shouldn't be complicated. WPS Office provides a highly compatible, lightweight alternative for offline and local document editing without the heavy overhead.

1. Download the Installer: Visit the official WPS Office website and download the free installation package.
2. Install the Software: Run the downloaded installer and follow the quick on-screen instructions to set up the suite.
3. Open and Edit Files: Launch WPS Office and instantly start editing your existing .docx, .xlsx, and .pptx files.

Seamless compatibility with Microsoft Word, Excel, and PowerPoint formats.Lightweight installation that frees up local storage and boots in seconds.Easily manage local document versions without worrying about hidden cloud storage bloat.Familiar, tabbed user interface for quick adoption without a learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint take so long to update storage metrics after I delete files?

SharePoint Online uses automated backend timer jobs to aggregate and report storage data. These jobs run on a set schedule across Microsoft's servers, meaning mass deletions or cleanups generally take 24 to 48 hours to reflect in the Active Sites usage reports.

Does the SharePoint recycle bin count towards my overall storage limit?

Yes, items residing in both the first-stage (site level) and second-stage (site collection level) recycle bins count against your total SharePoint storage quota until they are permanently purged.

Can retention policies cause hidden storage usage in SharePoint?

Yes. If a retention policy is active, deleted or modified documents are kept in a hidden Preservation Hold library. This data consumes storage space but is often overlooked because it is not readily visible to standard users in normal document libraries.

Office Quick Solutions