Microsoft Excel format is a page-based format. This format converts your report contents into Excel cells on a page-by-page basis. Contents from multiple pages are exported to the same Excel worksheet. If a worksheet becomes full and there is more data to export, the export program creates multiple worksheets to accommodate the data. If a report object covers more than one cell, the export program merges cells to represent a report object. Microsoft Excel has a limit of 256 columns in a worksheet; therefore, any report object (or part of it) that is added to cells beyond 256 columns is not exported. This export format retains most of the formatting, but it does not export line and box objects from your report.
Microsoft Excel - Data only, as the name
suggests, is a record-based format that concentrates on data. Even
so, this format does export most of the formatting, too. Unlike
Microsoft Excel format, Microsoft Excel -
Data only format does not merge cells, each object is
added to only one cell. This format can also export certain kinds
of summaries in Crystal Reports as Excel functions. The summaries
that are supported are SUM, AVERAGE, COUNT, MIN and MAX.
Crystal Designer export Excel details , 4382901 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem