Each section exported to Microsoft Office HTML creates one worksheet in the Microsoft Excel workbook even when there are multiple sections, unless you use the Microsoft Excel 2007 format (*.xlsx). Exported sections of the same Interactive Reporting document do not reference each other in the Microsoft Excel worksheet. For example, if a Table section is created from a Results section, both exported sections are displayed as independent worksheets in Microsoft Excel.
Exported sections of the same Interactive Reporting document do not reference each other in the Microsoft Excel worksheet. For example, if a Table section is created from a Results section, both exported sections are displayed as independent worksheets in Microsoft Excel.
An Internet Explorer browser can show more than 65,536 rows, and an Microsoft Excel spreadsheet has 256 columns and a maximum of 65,536 rows. If an exported section has more rows than the Microsoft Excel row maximum, all rows are exported to the source rows available, but only 65,536 rows are processed for Microsoft Excel to process any formulas. In this case, Microsoft Excel truncates the exported data in the section.