I created a view that will not display because it contains over 5000 entries. Now I cannot edit it or delete it.

Anyway to get rid of it?

  • Office 365 or on-prem?
    – Mike2500
    May 12 '15 at 16:36
  • How many items approx return in that view?
    – Waqas Sarwar MVP
    May 12 '15 at 16:42

One thing, if you using the on prem version of SharePoint then an easy solution is

  • increase the List view threshold to above the number of items in that view
  • delete the view
  • reset the threshold back to normal.


For Office 365, check Office 365/SharePoint Online – Getting Around the List View Threshold Error

  • Thanks. We are using Office 365. I will try this solution and see if it works.
    – markovich
    May 13 '15 at 20:51

Here is what you can do to fix the issue without deleting View.

First try to remember if the View is a filtered view. If it is not filtered then we have not choice rather delete the view.

Now open the list settings and - Open Indexed columns and add the columns which you used in the Filter criteria.

Next try opening the view and it will work as expected.

Removing View using PowerShell

$SPWeb = Get-SPWeb http://weburl
$List = $SPWeb.Lists["ListName"]
$View = $List.Views["ViewName"]
  • i highly doubt whether this will work or not because untill the threshold of the list is changed it may not allow even with powershell.
    – kesava
    May 12 '15 at 22:18

I learned a trick from HNR949

His solution was to open the large list in MICROSOFT ACCESS and delete some or all Items from the List.

When your List is again below Threshold then you are free to do what you like with your List.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.