I'm using Crystal Reports 2008, and I'm exporting to Excel 2007. My report has more than the 255 columns allowed by Excel 2003, but not more than the max Excel 2007 can hold.

I didn't see Excel version 12 (2007) in the available export lists, so I created an ODBC connection that did allow me to select .xlsx (Excel 2007) for export.

Alas, on export, the report still caps at the 255 column mark.

Is there a workaround for this, or perhaps a more direct way of getting CR'08 to accommodate the greater capacity of Excel 2007 and the .xlsx format?

Thanks for any help!

I should amend this. I haven't visited the problem in a little while, so I remembered it incorrectly. The issue is importing FROM an .xlsx file (one that has more than 255 columns). This doesn't find its way into the CR resulting rpt, despite having set up a custom ODBC connection that allowed me to select .xlsx as the file type (using the typical import feature doesn't allowing selecting Excel versions that high).

So, still rather stuck. I've though of having the data in more than one sheet, but would rather not, as this is survey data brought into Excel from another program, and thus putting it into different sheets would have to be done by hand (or by macro).

Thanks.