Greetings, I'm using SharePoint 2007. to administer several small surveys with similar questions to different audiences that I would like to pull together into one spreadsheet and pivot table to summarize all of the surveys at once. I would like to either set up the surveys so the data feed into a pivot table already set up - or to be able to extract data from sharepoint, drop them into the excel file and refresh the pivot table easily. I have tried extracting the data - as I don't know where to start with the first option. When I extract the data, the spreadsheet is formatted with column headers - which is great - but when I pull together multiple extracted spreadsheets, I can't get rid of the column headings. So I have a spreadsheet with 50 rows of actual data and 5 rows of headings, which I can't seem to delete. I'd like to display averages in the consolidated data spreadsheet. I'd like to know is there an easier and more automatic way to consolidate survey results in sharepoint?

Hi SuzSharepoint, From your description, I understand that you want to export the survey results from multiple surveys to a spreadsheet. And you want to pull the spreadsheets together, but the headers are not allowed to delete from the summary spreadsheet. Please try these solutions: Solution 1: Only copy the spreadsheet without header (only copy the rows below the header) and then paste it to a spreadsheet. Solution 2: Create a data view with the data source from multiple surveys. 1. Create a linked source. Link source could join the data from server data sources. Create it follow this link and choose merge all the datasources. http://office.microsoft.com/en-us/sharepoint-designer-help/add-a-linked-data-source-HA010115404.aspx 2. Create a data view web part with the link source. (Create a Data View) 3. Save the page and open it in browse. Right click the data view web part, click Export to Microsoft Excel. Solution 3: Create workflows for all the survey. Copy all the responses to one survey. Thanks & Regards, Emir