I am new to SharePoint (2007 version) so please excuse any basic errors. I have created a survey in SharePoint that has a mixture of yes/no, multiple choice and free form text answers. Prior to sending it out to the survey group I have tested it extensively and all the branches seem to be working so I thought I would export it to Excel to have a quick look at the data and create some tables, graphs etc.
I am able to export the file as a excel query file but when it opens it holds no data even though in the survey results page in SharePoint the test responses are there. Is there a minimum amount of responses required for it to work or am I doing something wrong. I don't really want to send out the survey until I am comfortable that I can export and analyse the results.
Thank you for any advice you may be able to give to a newbie.