Last day I was not able to export the responses of a sharepoint survey which has multiple rating scale questions.
I removed '&' from the questions .I created a new page in the site with single dataview using sharepoint designer. But none of them did not work for me.
At last resolved the issue by removing 'tabs' from the questions. It happened when I copied questions from a word document, while I created survey.