exporting to excel from sharepoint returning blanck sheet

Godfrey Obong 1 Reputation point
2020-07-29T09:53:57.893+00:00

Hi, am currently not able to export my SharePoint list to excel. Instead the query generated returns a blank excel sheet. This is really frustrating and any assistance will be greatly appreciated.

Godfrey

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,684 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Itch Sun-MSFT 2,556 Reputation points
    2020-07-30T05:58:24.757+00:00

    What view is used when the list exports excel?

    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 Events" view instead of any other view.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.