The Excel 2000 format can be viewed with versions of Excel 2000 and later. It supports up to 65,536 rows and multiple sheets. The Excel 2000 format is only available in ACI when Application Firewall validation is disabled.
Excel 2000 single sheet format offers improved security. Excel 2000 may have cookies in the URLs to spreadsheets, which could be used to illegally impersonate a user. Excel 2000 single sheet format does not use outgoing URLs. However, there is a limit of 65,536 rows, and page breaks for multiple-author pages are ignored.
Excel 2002 format and Excel 2000 single sheet format also offer the following benefits:
Both work with SSL protocol.
Both work with a single signon.
Secure reports can be accessed without subsequent signons because the system automatically identifies users and provides security information.
Both work with Netscape 7.01.
Spreadsheets are contained in a single file for reliable spreadsheet navigation.
The ACI full date format does not always appear correctly in Microsoft Excel 2000 if it is on a system with a regional setting other than English. This does not occur with Microsoft Excel 2002 or 2003 versions. To fix this, reapply the proper format in Excel.
Excel 2007 format renders report output in native Excel XML format, also known as XLSX, that provides a fast way to deliver native Excel spreadsheets to Microsoft Excel 2002, Microsoft Excel 2003, and Microsoft Excel 2007. Users of Microsoft Excel 2002 and Microsoft Excel 2003 must install the Microsoft Office Compatibility Pack, which provides file open and save capabilities for the new format. The output is similar to other Excel formats, with the following exceptions:
Charts are rendered as static images.
Row height can change in the rendered report to achieve greater fidelity.