Questions tagged [export-to-excel]

The tag has no usage guidance.

1
vote
1answer
19 views

Import Spreadsheet to Datasheet SharePoint with calculating columns

Is there a work around in importing Excel Spreadsheet data (copy and paste) into Datasheets with calculating columns? For some reason, when I import it, the calculating column doesn't populate and it'...
-1
votes
1answer
19 views

Limit of items selected in SharePoint list

I have found and deployed a nice .wsp package that allow you to select items in a sharepoint list or filter a list and it will only export the selected/filtered items. The catch is, you have to ...
0
votes
0answers
15 views

Filtered, large list exporting

I'm currently managing a large list (just over 5000 items) and have a filtered view using indexed columns that is returning 143 items. I want to export those 143 to Excel. I'm getting an error ...
0
votes
2answers
28 views

Error while trying to “Export to Excel” a custom list in SharePoint Online

I am using SharePoint Online and Excel 2016. When I try to "Export to Excel" a custom list, I get the following errors: My version of Excel 2016 comes from Microsoft Office Professional Plus 2016. I ...
0
votes
0answers
11 views

creating a file made of different lists and then exporting to Excel

Is it possible to create a list in SharePoint which is made up of multiple different lists and then export them to Excel? So, for example, let's say I have 10 folders and within those folders, I have ...
0
votes
1answer
103 views

PNP script for all users with Full Control within a Site collection's sub-sites

Via PNP/CMOS, we are looking to export all users that are of Full Control permission level in an on-premise site collection. This site collection could have 300+ sub-sites. We are trying to figure ...
0
votes
0answers
54 views

Export SharePoint 2013 list big data to Excel

I have a SharePoint list with 13879 items, so when I am trying to export the list to Excel, data doesn't export. It is blank sheet and looks like this. (where column1, column2... are SharePoint list ...