Exporting a list view which only return 400 items and it is using indexed filters will raise this error "You do not have permission to view the entire list becuase it is larger than the list view threshold enforced by the admin"

john john 916 Reputation points
2023-07-26T16:14:54.1966667+00:00

We have a list view which contain less than 400 items, the list it self contain 33,000 items

Now we have a list view which have this filtering and sorting based on indexed columns (all the fields Short code + Design Period + FY are indexed):-

User's image

and when we try to export the list view using Excel >> we got this error:-

User's image

although the list view only contain less than 400 items and we can export it to csv. so why we can not export a list view which return less than 400 items and has all its filtering using indexed columns to excel ??

Thanks

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,213 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
2,563 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ling Zhou_MSFT 11,775 Reputation points Microsoft Vendor
    2023-07-27T05:45:44.0433333+00:00

    Hi @john john

    Thank you for posting in this community.

    I tested you question in my side, and I did not reproduce your problem. There may have been some sort of problem with the export process, which defaulted to exporting all the items.

    However, we can work together to narrow down and resolve the situation. So, please kindly provide more information below to let us work further.

    1. I would suggest that you recreate a view and add filtering rather than making changes in an existing view. To avoid errors, you can temporarily set the view to be exported as the default view. Retry the export and then see if the problem persists.
    2. Are other users facing the same problem? View through another computer or account.
    3. Whether all SharePoint lists have the same problem? You could create a new SharePoint list to check.
    4. Check if the same issue occurs with other SharePoint site collections.
    5. You could try to clear browser cache then restart it.
    6. Try to use a different browser or your browser's InPrivate mode to see if the same error occurs.

    Thank you for your time and efforts in advance.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.