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