SharePoint Designer Cannot open list with 5000 items

%3CLINGO-SUB%20id%3D%22lingo-sub-927882%22%20slang%3D%22en-US%22%3ESharePoint%20Designer%20Cannot%20open%20list%20with%205000%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-927882%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20not%20able%20open%20a%20SPO%20list%20in%20the%20SharePoint%20designer%20that%20have%20more%20then%2015000%20items%2C%20none%20of%20the%20views%20running%20into%205000%20threshold%20issue.%20I%20need%20to%20modify%20list%20forms%20in%20SharePoint%20Designer.%20In%20the%20designer%20I%20tried%20to%20get%20to%20the%20list%20from%20List%20and%20Libraries%20and%20from%20All%20Files-%26gt%3BList-%26gt%3BCustom_List%20but%20none%20of%20them%20worked%20and%20I'm%20keep%20getting%20%22The%20attempted%20operation%20is%20prohibited%20because%20it%20exceeds%20the%20list%20view%20threshold%20enforced%20by%20admin%22.%3C%2FP%3E%3CP%3EPlease%20suggest%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E-Sal%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-927882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDesigner%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-978498%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Designer%20Cannot%20open%20list%20with%205000%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-978498%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20the%20same%20issue.%20Would%20be%20good%20to%20get%20a%20reply%20from%20Microsoft.%20Can%20SPD%20not%20handle%20lists%20over%205000%20items%3F%20In%20which%20case%20it's%20time%20to%20look%20for%20a%20non-SharePoint%20solution%20for%20me.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-994240%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Designer%20Cannot%20open%20list%20with%205000%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-994240%22%20slang%3D%22en-US%22%3EI%20had%20the%20same%20problem%20and%20opened%2Ca%20ticket.%20msft%20got%20back%20to%20me%20the%20next%20day%20in%20an%20email%20and%20saiid%20they%20found%20the%20'root%20cause'%20.%20I%20can%20now%20open%20my%20list%20in%20SPD.%3CBR%20%2F%3E%3CBR%20%2F%3EHas%20it%20been%20fixed%20for%20you%3F%20If%20not%2C%20yo%20may%20need%20to%20open%20a%20ticket.%20Ticket%20number%20was%2017395226%20with%20isha%20if%20that%20help%20anyone.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1208126%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Designer%20Cannot%20open%20list%20with%205000%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208126%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F108593%22%20target%3D%22_blank%22%3E%40Melanie%20Howes%3C%2FA%3E%26nbsp%3B%20we%20are%20also%20having%20significant%20issues%20with%20the%205000%20view%20limit%20for%20lists%20that%20we%20are%20using%20in%20vlook%20ups%20that%20worked%20in%20previous%20version%20of%20sharepoint%20but%20have%20now%20all%20gone%20faulty%20since%20migrating%20everything%20into%20O365%20SharePoint%20Online.%20Indexing%20columns%20does%20absolutely%20nothing.%20I%20have%20used%20every%20single%20trick%20in%20the%20book%20and%20nothing%20works.%20Once%20again%2C%20Microsoft%2C%20this%20is%20just%20not%20good%20enough.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1208127%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20Designer%20Cannot%20open%20list%20with%205000%20items%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1208127%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8901%22%20target%3D%22_blank%22%3E%40Russell%20Gove%3C%2FA%3E%26nbsp%3BOK%2C%20I%20will%20raise%20through%20my%20IT%2C%20to%20raise%20with%20microsoft%20to%20look%20at%20ours%20too.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi,

I'm not able open a SPO list in the SharePoint designer that have more then 15000 items, none of the views running into 5000 threshold issue. I need to modify list forms in SharePoint Designer. In the designer I tried to get to the list from List and Libraries and from All Files->List->Custom_List but none of them worked and I'm keep getting "The attempted operation is prohibited because it exceeds the list view threshold enforced by admin".

Please suggest?

 

Thanks,

-Sal

4 Replies
Highlighted

I'm having the same issue. Would be good to get a reply from Microsoft. Can SPD not handle lists over 5000 items? In which case it's time to look for a non-SharePoint solution for me. 

Highlighted
I had the same problem and opened,a ticket. msft got back to me the next day in an email and saiid they found the 'root cause' . I can now open my list in SPD.

Has it been fixed for you? If not, yo may need to open a ticket. Ticket number was 17395226 with isha if that help anyone.
Highlighted

@Melanie Howes  we are also having significant issues with the 5000 view limit for lists that we are using in vlook ups that worked in previous version of sharepoint but have now all gone faulty since migrating everything into O365 SharePoint Online. Indexing columns does absolutely nothing. I have used every single trick in the book and nothing works. Once again, Microsoft, this is just not good enough.

Highlighted

@Russell Gove OK, I will raise through my IT, to raise with microsoft to look at ours too.