End users doing export of list to Excel by going to List and choosing Export to Excel. Well this works fine, but the user wants only some columns to be exported not all columns.
I've created "another view" with only these 5 columns selected and clicked on export to Excel, but it still exports all 20 fields (all fields from the list).
I don't know why it Exports all columns to Excel.
The strange thing is : When I put Filter on the view, this works fine...
!!!And the user is now exporting and deleting the 5 columns manually from Excell, which we should automate.!!!
I googled and I was not able to find a solution, please advise what I'm doing wrong.
The solution should be workable and this is repetitive "Export to Excell task for End-User" with these 5 columns.
ps: currently we are using SharePoint 2010 and next month we will move to SharePoint 2013.
How can I prevent the "path" and "item type" be exported.