Export to Excel

[rdlwriter]

I have a report that contains 74 columns and approx 1530 rows.. when exported to Excel and try to open get the error "Repairing ....xls.

Is there a row/column limitation? I have looked on MS site and it states the rows of 65000, but cant seem to find a row/column limitation.. all I know is that it wont work.

Any suggestions for a work around? (besides csv).

Regards

 

[MisterMo]

I have noticed that when you export to excel if you have header, footers and/or group slightly offline it will create merged cells which are a pain to work with.

it could be that what causes the error lays in the way the report is formatted.

When I create a report that has to be exported to excel I do:

1) no report header or footer, no list

2) 1 single table with multiple table headers so that I can include report title, parameters and various descriptions that I would normally put on the report header.



-Mo

 

[xlbo]

probably to do with merged cells - as stated before, if your header / tables are not exactly lined up, excel merges cells / columns to compensate. There are a max of 256 columns in excel so if there are a lot of merged cells, it is not beyond the realm of possibility that in trying to keep the layout exact, the no. of columns is too much for excel to handle

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question