Forum Discussion

slohombre's avatar
slohombre
Brass Contributor
Jan 31, 2021

Error when exporting Sharepoint list to excel

Hi, all. 

 

I am trying to export a sharepoint list from sharepoint online in modern format via the built in “export to excel” on the list ribbon. I get an error message and it does not export to the list to excel.

 

I’ve seen this problem quite frequently in the community - is this a bug in sharepoint? Does Microsoft have a fix for this? Is there an effective workaround?

SharePoint Online

2 Replies

  • Matthew Carter's avatar
    Matthew Carter
    Iron Contributor
    Mar 03, 2022

    slohombre 

    Is it something like this?
    https://techcommunity.microsoft.com/t5/sharepoint/unable-export-to-excel-from-sharepoint-list-using-quot-export-to/m-p/792795#M33160

    Possible work around from that link is:
    My workaround is to
    Go to the Site Assets Library on the same site
    Create an Excel file
    Data > Get Data
    Connect to SharePoint Online list

     

    I took the file, did a query and then saved it as an Excel file.  I saved it to the Site Assets Library and then opened it in Excel (client / desktop) and then did a refresh content or connection and when I updated the List item, say adding a 1 to a name in a row, it refreshed!
    NOT a great work around when it should work, however it does if it is for a List item that is available to edit for persons or read only, yet the rest of the site is NOT accessible.

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Jan 31, 2021

    slohombre  it's not a general issue as I've never had a problem exporting to Excel. Sorry, I can't suggest anything which doesn't help you at all but hopefully else will be able to offer some insight.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

Resources