Wednesday, August 13, 2008

Not able to Export Survey list with more than 100 responses to Excel Spreadsheet

Issue:- While Exporting a Survey List, only 100 responses are exported.

No Error is logged or generated.

Resolution:- Open the Sharepoint Survey List in Sharepoint Designer. For both Overview.aspx and Allitems.aspx do the following.

Change the RowLimit element Paged property set to FALSE.
RowLimit Paged="FALSE">100</RowLimit
Change the value to True (using SP Designer 2007), otherwise it will limit the items display and export to excel.
RowLimit Paged="TRUE">100</RowLimit

1 comment:

Anonymous said...

Thank you for the tip...worked perfectly