Export to excel ignores the filtered result and displays all the results..


  • When trying to export to excel, a list data in sharepoint and used filter criterion, it ignores the filtered value and displays the general sequenced value in excel sheet. Also when i set the max item count to 100 and suppose the list is having more than 500 items and when i go to next page having items from 101 to 200 and then do export to excel, it gives the first 100 values not from 101 to 200.

    Can anyone suggest, is this a sharepoint bug or some configuration changes is required to eliminate this error..

    Thursday, January 07, 2010 6:11 AM

All replies

  • Change the item count to "more than 500".

    Or perhaps better create a new View that has (say) an item Limit of 1000 that will be used for your exporting to Excel.

    FAQ sites: (SP 2010); (v3) and (WSS 2.0)
    Complete Book Lists (incl. foreign language) on each site.
    Thursday, January 07, 2010 6:45 AM
  • Hi Mike,

    Thanks for your reply, but filtered value is not coming in excel sheet. Every time it gives only first 100 results. I have checked, even i will set the max item limit more than the items in the list, it doesn't give the filtered result.

    Is this a bug with sharepoint export to spreadsheet functionality in a sharepoint list.

    Thursday, January 07, 2010 7:24 AM
  • Hi Ravish,

    What’s your version of SharePoint, did you install SP2?

    Did you set the item limit through “modify the view” and choose “Limit the total number of items returned to the specified amount”? If so, I’m afraid that it is by-design behavior that it will show the first 100 value. Regarding the filter, if you filter the view by using the filter in “Modify the view” and the item limit configuration is the same as I mentioned before, it should only show the items which are filtered after you export to excel.

    If I misunderstand your concern, please provide the detailed steps about the configuration for me to reproduce your issue. Thanks.

    Lu Zou


    Monday, January 11, 2010 10:04 AM
  • Hi Lu,

    Thanks for your reply. Let me represent the problem once again. I have a sharepoint custom list. when i am using windows 2000 machies and office 2000 client and fire the Export to spreadsheet event, it gives only first 100 items, Yes the item limit set for this list is 100. So i understand that, it should by design show only 100 items. But at the same time when i am using vista operationg system and office 2007 client and fires the same event, it gives me all the items in the list.

    The second starnge behaviour is that, when i am setting a filter criterion and getting the items as per the filter, i have set on a column, using sharepoint standard OOB feature, It doen't give me filtered result. In case of office 2000  client it gives first 100 results if i set item limit as 100 and in case of office 2007 it gives me all the items, without doing any filteration.

    The other strange behaviour is that, if i will go to next page, that means , if i am in the page where the items starts from 101 and ends at 200, and do the export to excel, it gives me first 100 results..not the items from 101 to 200

    My question is, is this the limitation of office 2000 client that it will export the data only for the first page and also with office 2007 client it can not filter the items.

    I hope this will make your understanding about this problem more clear.

    Tuesday, January 12, 2010 3:24 AM
  • Hi, Were you able to find work around for above mentioned issues? I am facing the similar issue while exporting the filtered data from SharePoint List. All of the data is getting exported and not only filtered data. Please let me know if any workarounds are available or is it a known bug? Regards, Amit
    Monday, December 20, 2010 5:41 AM
  • Try this solution
    Tuesday, June 04, 2013 10:58 AM