INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

Microsoft Excel Worksheet and Workbook Limitations that Affect FRx and Exporting to Microsoft Excel

Entry Type: Informational

Product: FRx

Application: FRx Desktop

Version Reported: 6.7.10343 (SP10)

Subject:

Microsoft Excel Worksheet and Workbook Limitations that Affect FRx and Exporting to Microsoft Excel.

Possible Resolution:

Microsoft FRx provides customers the ability to export their reports to Microsoft Excel. This article defines the key limitations that Microsoft Excel has within its worksheets and workbooks that can affect the FRx export.

The Microsoft Excel 2003 limits are outlines below:

• Open Workbooks is limited by available memory and system resources.
• Worksheet size is limited to 65,536 rows.
• Worksheet size is limited to 256 columns.
• Column Width is limited to 255 Characters.
• Page Breaks are limited to 1000 horizontal and vertical (Note: FRx does not provide a vertical page break capability.)
• Linked sheets is limited by available memory.

For further information on the limits and specification in Microsoft Excel 2003, see http://office.microsoft.com/en-us/excel/HP100738491033.aspx?pid=CH101030621033

The Microsoft Excel 2007 limits are outlined below:

• Open Workbooks is limited by available memory and system resources.
• Worksheet size is limited to 1,048,576 rows.
• Worksheet size is limited to 16,384 columns.
• Column Width is limited to 255 Characters.
• Page Breaks are limited to 1026 horizontal and vertical (Note: FRx does not provide a vertical page break capability.)
• Sheets in a workbook is limited by available memory (default is 3 sheets).
• Linked sheets is limited by available memory.