Forum Discussion
Export List to Excel for non-editor
Have the "New Experience" for lists in tenant. A "reader" user needs to be able to get the list into Excel for local manipulation (doesn't need to update list in SharePoint). Export To Excel option...
Good question could you try to go in excel and open the list from there?
Web Query returns no items is basically what the message said when I tried.
It worked for me today (both for SP library - many tech. records and also for SP list) - maybe you have to authorize properly.. (?)
I'm using 2010 not 2016.
With lastest version of Excel 2016 you are able to import SharePoint list to Excel Sheet (Data > New Query > From Other Sources > From SharePoint List)
