Excel fails to download SharePoint List data

Federico Coppola 1,181 Reputation points
2020-10-29T19:38:13.877+00:00

Hello,
I have an Excel file that has got a query.
This query permit to access to a List of SharePoint and download data from this list.
In this way accounting employees can easly read data from this list using a simple Excel document.

It worked fine for a long time, but not now.
In fact user receive this error when they try to get data from the SharePoint List using Excel File:

You do not have permission to view the entire list because it is larger than the list view threshold enforced by the administrator

I have checked SharePoint List and I have seen that this List has got more than 5000 elements

36108-immagine.png

After that I have tried to create a filter of this list but without success.

Is there a way to collect just the last 500 records (for example) inside the Excel File and don't receive the error message?
I think that Excel File try to download all SharePoint List records.

This is the query inside Excel File:

36046-immagine.png

How can I solve this issue?
Thanks so much for your help
Federico

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,682 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,645 questions
0 comments
Accepted answer
  1. Federico Coppola 1,181 Reputation points
    2020-11-17T09:30:41.527+00:00

    Hi all,
    I have read again all your answare to support me and I have found the solution!

    1) I went on SharePoint list and Edit settings of SharePoint List
    At the moment I have a "main view" of this SP List and this view has got filters.

    2) I have created a new view called "ExcelExport" starting from the existing "main view"

    40240-image.png

    3) I removed all filters and I checked that all variabiles has got default values
    40372-image.png

    4) I open in my browser the list using this view so I can catch query for excel file
    40392-image.png

    I deleted old query from Excel file and I imported the new query that use the new view (dedicated to Excel export). My file works again!

7 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Federico Coppola 1,181 Reputation points
    2020-11-12T14:10:24.987+00:00

    Dear @DattaPawar-2050,
    thanks so much for your reply.

    I'm using SharePoint on Office365.

  2. Dattatray Patil 86 Reputation points
    2020-11-09T17:00:25.23+00:00

    Could you please check indexed column in the list?

    Also could you please increase the list threshold limit in Central Admin if this is on-premise server (if you are using).

    0 comments
  3. Federico Coppola 1,181 Reputation points
    2020-11-09T15:50:52.863+00:00

    Hi @Elsie Lu_MSFT ,
    I have found the sharepoint List and View.

    38414-image.png

    After that I have clicked on button about excel export, I have opened the file and I get the same error!

    In fact I have more than 5000 elements inside this list.
    I have changed from Classic to Modern GUI but nothing change.

    How can I solve this issue?

    0 comments
  4. Federico Coppola 1,181 Reputation points
    2020-11-03T15:04:03.217+00:00

    Dear @Elsie Lu_MSFT ,
    Thanks so much for your help.

    I will check it as you suggest

    I will keep you updated.

    Thanks so much
    Federico

    0 comments