Questions tagged [export-to-excel]

The tag has no usage guidance.

21 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
30 views

Exporting a SharePoint list to Excel is exporting the entire list, not just the view I want

Exporting from SharePoint Online list should only include the items in the view. However, when I export, I am getting all the items in the list. I tried various browsers. Anyone know a workaround? ...
1
vote
2answers
666 views

Export to Excel erroring when connected to VPN

In SPO, when I use the "Export to excel" functionality when connected to VPN, I receive the below error. "The server you are trying to access is using an authentication protocol not supported by this ...
1
vote
0answers
35 views

Problems with exporting a list to Excel

I have modified my view and selected just the columns that i want to show. But when I export the content to excel I can see more columns. (In my nomal view I am not seeing them, just when I export it ...
1
vote
0answers
209 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
1answer
16 views

Inserting data into Excel from PowerApps

I have a PowerApps app that is fronting a SharePoint data source. My customer has an Excel spreadsheet they use for reporting purposes and would like to be able to export data from the PowerApps ...
0
votes
2answers
22 views

Export SharePoint calendar to excel in same calendar format

I want to export the calendar list into excel, I am aware of list ribbon - export to excel. Its exporting all events in list format, I want the exported excel to be in month view with all the dates ...
0
votes
1answer
28 views

.cvs export of sharepoint list removes leading zero's

My site includes functionality that exports a list as a .csv file. I can't change the fact that the list is being exported as a .csv. The problem is that when the list is exported, the leading zeros ...
0
votes
1answer
353 views

How can I export a sharepoint online list with version history enabled to excel?

I have enabled version history on my custom list. Now when i do an export to excel all the multiple text fields don't show any data at all. How can i get it to export all the fields with data and the ...
0
votes
1answer
54 views

Why Rich Text fields which have “Append changes to existing Test” will show empty cell when i export our custom list to excel

We have an online classic team site and inside this site we have created a custom list, which contain 2 fields of type rich text + have "Append changes to existing text" set to yes ,as ...
0
votes
0answers
13 views

Interview Question (Need suggestions)

The scenario is that there is a Sharepoint 2013 List that has 200-250 items on the list. every Saturday, these items should be sent to a specific user/group in email as an attachment. how we can do it?...
0
votes
1answer
25 views

SharePoint List exporting differently to excel display

We have recently upgraded to SP 2016. Our excel reports extract data from linked SharePoint lists. Following the upgrade, the lists display fine in SharePoint, however are disjointed in excel with ...
0
votes
1answer
21 views

Exporting Calendar to Excel throws an error

I am trying to export a calendar with a list view in chrome,however I am getting the following error: WEB 1 https://[site]/_vti_bin/owssvr.dll?XMLDATA=1&List={3552683E-AA60-440B-BE31-015A31B047D2}...
0
votes
2answers
516 views

How can I use export to excel and get the full file path?

In the past when I used export to excel the full path was shown as "../../../../../../../../Departments/EIDepartment/Shared Documents/Area Class Reference/FIGURE 2.pdf", which I could use as a ...
0
votes
2answers
78 views

Complex list Export to excel

I have a complex list with more than 100 columns and around 55 lookups. I need to export the list containing all the fields to an Excel File. How can i do this considering this error: This view cannot ...
0
votes
1answer
79 views

Export SharePoint List to Excel

I have been getting an error when I try to export a Contacts list from our SharePoint online environment to excel. It downloads a query file but says "Cannot connect to the server at this time. ...
0
votes
1answer
735 views

How to export SharePoint list to excel and save it in a sharepoint list

I want to export sharepoint list in a excel and save it in a sharepoint list.I am able to save it in local.So I am looking to generate excel and save the same in sharepoint list by csom c#
0
votes
2answers
2k 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
1answer
572 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
101 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 ...
0
votes
3answers
357 views

How to click export to excel in SharePoint Online

I have 3 lists in SharePoint. But in 2 lists different button "Export to Excel" can be click. but in 1 list, it cannot be click.
-1
votes
1answer
120 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 ...