For datasets exceeding 200 questions, you will need to manually generate the Analyser report. Simply export the dataset as a normal Excel file (not as the Analyser), then copy the entire data sheet into a blank version (attached below) of the Analyser (with the Move/Copy sheet function, not as a cell range) with a unique sheet name, and on the 'Config' sheet change the Data sheet name to whatever this unique name is. You will also probably have to convert all numbers saved as text back into numbers.
To do this:
- First, switch sheet Calculation to Manual. Without this, the process can take hours as it recalculates the entire workbook between each individual conversion.
- Find the top-left-most cell that has a number saved as text, and select this cell and everything to the right and below it in your dataset.
- Go back to the top-left-most cell of the range you have now selected, click on the little comment flag next to it, and choose 'Convert to Number'.
- Switch Calculation back to Automatic.