Microsoft Lists slow to open and how to fix it quickly

Slow opening in Microsoft Lists is either a client issue (browser, device, network, extensions) or a server/list issue (large list, complex view, unindexed filters, tenant throttling). Start with quick client checks—private mode, different browser/device, clear cache, disable extensions—and if the problem persists for multiple users, simplify the view and add indexes or ask an admin to check tenant health and throttling.

Why is Microsoft Lists opening slowly right now?

Microsoft Lists pages take noticeably longer than usual to display, or the list view never fully renders.

You see this when the page hangs on "Loading...", headers appear but rows are slow to render, or the view times out. The cause is usually one of two broad areas: client-side (browser cache, extensions, device CPU/memory, local network or VPN) or server-side (very large list, unoptimized view, heavy lookup/person/calculated columns, JSON column formatting, SharePoint service load or tenant-level throttling).

Fast way to separate those: open the same list in another browser, in a private/incognito window, or on another device. If the list loads normally in any of those, the problem is local. If multiple people on different browsers and networks see the same slowdown, it’s likely list- or tenant-side.

Is this problem happening only to me or to others in my org?

Before changing list settings, confirm scope so you don't chase the wrong problem.

• Product/versions: Applies to Microsoft Lists in SharePoint and the Lists app in Microsoft 365 web; behavior is consistent across Edge, Chrome and Firefox.
• Privileges: No admin rights required for the checks below.

1. Open the list in an Incognito/Private window.

Open browser -> New Incognito/Private Window

2. Open the list in a different browser (Edge vs Chrome vs Firefox).
3. Sign in from another device (phone or another PC).
4. Ask a colleague to open the same list and report load time.

Expected result: If the list opens normally in private mode or on another device, the issue is local to your browser or device. If colleagues confirm slowness from different networks, include that information and the time of occurrence when you contact your Microsoft 365 admin.

Try these fast fixes you can do right now

Start with low-risk, reversible actions on your device and browser.

1. Clear the browser cache.

Browser -> Settings -> Privacy & Security -> Clear browsing data -> Cached images and files

Expected result: The list should load faster if stale cache caused rendering delays. If nothing changes, continue.

2. Open the list in a different browser.

Expected result: If the list loads normally in another browser, your primary browser’s settings or extensions are the cause.

3. Disable browser extensions (one at a time).

Browser -> Extensions -> Toggle off extensions

Expected result: Turning off a misbehaving extension should restore load speed. If disabling all extensions helps, re-enable them one-by-one to find the culprit.

4. Try the mobile Lists app or the SharePoint mobile app.

Expected result: If mobile loads quickly while desktop is slow, the issue is client-side.

5. Check your network: run a speed test and temporarily disconnect VPN.

• If VPN is on, turn it off briefly and retry.

Expected result: If lists open faster without VPN, the VPN or its route is adding latency.

6. Restart your browser or device.

Expected result: Frees stuck processes or memory problems that can slow rendering.

If none of these restore acceptable performance, move to list-level fixes.

Fixes for slow lists caused by the list itself

If tenant and service health look normal, the list content or view is often the cause. Make these changes in the list—start with non-destructive edits (views) before changing columns or items.

1. Switch to a simpler/default view.

List -> View options -> All items (or Create new view -> Standard view with minimal columns)

Expected result: A basic view with few columns and no formatting should load faster. If it does, the original view is the problem.

2. Reduce items returned by the view (filter or paging).

List -> View settings -> Item limit -> Limit the number of items returned

Expected result: Loading a smaller subset speeds rendering. If that helps, make a filtered view the default.

3. Add indexed columns for common filters.

You need appropriate list permissions to create indexes.

List settings -> Indexed columns -> Create a new index

Expected result: Filtered views using indexed columns should perform much better. If creating an index fails on a very large list, escalate to an admin.

4. Remove or limit lookup, person/group and calculated columns in the default view.

Expected result: Views with fewer lookup/person/calculated fields render faster because each lookup can trigger extra queries.

5. Remove complex JSON column formatting or switch to an unformatted view temporarily.

Expected result: If removing formatting restores speed, simplify the JSON formatting.

6. Consider splitting very large lists or archiving old items.

Expected result: Smaller lists or segmented lists are faster; if performance improves after moving items, plan a permanent archive or split strategy.

If you can't apply these changes, or they don't help, escalate to an admin.

Admin and backend actions when list-level changes don’t help

These steps require SharePoint admin or Global admin privileges.

1. Check Microsoft 365 Service health and SharePoint health in the admin center.

Microsoft 365 admin center -> Health -> Service health

Expected result: If Microsoft reports an outage or degradation, wait for recovery. If no issue is reported, continue troubleshooting.

2. Review throttling and usage reports with PowerShell or the SharePoint admin center.

Connect-SPOService -Url https://yourtenant-admin.sharepoint.com
Get-SPOTenant

Expected result: Look for tenant settings or patterns that indicate throttling. If you see throttling, stagger heavy operations or contact Microsoft support.

3. Use SharePoint usage reports to find "hot" lists and users.

SharePoint admin center -> Sites -> Active sites -> Select site -> Usage

Expected result: Identify lists with high request rates or very large item counts.

4. Rework very large lists: split into multiple lists, use folders with indexed columns, or archive old items.

Expected result: Breaking a monolithic list into logical segments reduces query cost and improves load.

5. Verify and enforce column indexing and filtered default views on large lists.

List settings -> Indexed columns

Expected result: Proper indexing and filtered default views reduce full scans and help avoid throttling.

6. Review custom scripts, Power Automate flows, or webparts that run on list load; disable or optimize them.

Expected result: Removing or optimizing flows and scripts that run frequently or synchronously lowers load.

If these actions don’t remove the slowdown, collect timing details, browser and network info, and open a Microsoft support ticket with your tenant admin.

How to verify the problem is solved and keep Lists fast

Verify fixes by repeating the simple checks and measuring load.

1. Try the list in multiple browsers and a private window.

Expected result: Load times are consistent and acceptable across browsers and for colleagues.

2. Measure a before-and-after: note the approximate time it took to render previously and compare after the change.

Expected result: Noticeably faster rendering or elimination of timeouts indicates success.

3. Confirm list-level settings: the default view uses indexed columns and returns a limited number of items.

List -> View settings

Expected result: The default view uses indexed column(s) and an item limit or filter.

4. Prevention tips to keep response fast:

• Enforce indexed columns for commonly filtered fields.
• Keep default views minimal: few columns, no expensive lookups or heavy JSON formatting.
• Limit rows returned in the default view or use paging.
• Archive or split lists that grow very large.
• Monitor usage and set alerts for lists with abnormal request patterns.

If performance regresses, capture exact times, browser/device, steps to reproduce, and server-side findings before escalating to support.

Conclusion

Start with client-side checks (private mode, different browser, clear cache, disable extensions). If multiple users are affected, simplify the default view, add indexes and remove heavy column types or formatting. If those changes don’t help, have an admin check tenant health, throttling and usage and consider splitting or archiving very large lists. Collect clear reproduction details before contacting support.

Frequently Asked Questions

Why does a list with few columns still load slowly?

Few visible columns doesn't guarantee a light view. Lookup, person/group and calculated columns and JSON formatting can trigger extra server queries or heavy client rendering. Test with a plain view that excludes those column types to see if performance improves.

Can large attachments make Lists slow?

Attachments increase storage but usually don't slow list rendering unless the view requests previews or an automation loads attachments. If your view or a flow tries to render or fetch attachments, that can add latency.

Will indexing always fix slow filtered views?

Indexing helps when the filters use those indexed columns and the filter narrows results. If the filter can't use an index or the list is extremely large, you may need to split the list or archive old items.