<div>
What's the size limit set by the admin? Also, any way to segment the list so that you can download it in smaller sets?
</div>


What's the size limit set by the admin? Also, any way to segment the list so that you can download it in smaller sets?

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
We have a process that tries to pull a list (50k rows), from sharepoint with the help of a web inquiry file.<br />
When it tries to open the .iqy file with excel, we get below error dialog titled &quot;microsoft office&quot;:<br />
<br />
&quot;you do not have permission to view the entire list because it is larger than the list view threshold enforced by the administrator&quot;..<br />
<br />
We tried reaching out to the sharepoint admin but &nbsp;they are strict with the already set limit for the list.<br />
<br />
Is there any way we may resolve this?<br />
<br />
Please help.
</div>
</div>


Hi Experts,

We have a process that tries to pull a list (50k rows), from sharepoint with the help of a web inquiry file.
When it tries to open the .iqy file with excel, we get below error dialog titled "microsoft office":

"you do not have permission to view the entire list because it is larger than the list view threshold enforced by the administrator"..

We tried reaching out to the sharepoint admin but  they are strict with the already set limit for the list.

Is there any way we may resolve this?

Please help.

web inquiry file opened as excel error - sharepoint

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.