Share via

export to excel is coming up with empty from list

sns 9,231 Reputation points
2020-12-21T13:00:33.56+00:00

Data after export to excel is coming up with empty from list. Please refer attached screenshot.
List has data but still we see below out put when export to excel
This is for all view in the list.
Please help
49875-capture.jpg

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,900 questions
Accepted answer
  1. Echo Du_MSFT 17,141 Reputation points
    2020-12-22T02:51:00.6+00:00

    Hi @sns ,

    We found that the problem was in the view parameters. If a view had filter parameters, it'll try to use those in the spreadsheet as well. However Excel won't be able to access any HTML/ASP.NET controls (which it won't embed in the spreadsheet), and it also won't be able to read from the querystring because there is none to read from.
    I suggest you use the "All Items" view instead of any other view.

    50216-1.png

    50217-3.png

    Thanks,
    Echo Du

    ===============

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    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.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest