Wright Williams & Kelly

Factory Explorer® v2.3
Technical Alert #11
Excel® Run-Time Error
When Creating Outputs

Summary: In some cases, when output results are placed in an existing Excel workbook on Factory Explorer®'s 'Analyze Output' dialog, Excel may generate a run-time error. This error will occur if the workbook where the results are to be placed already contains the maximum number (256) of built-in and custom number formats. To avoid this error, remove some custom number formats from the workbook where the results are to be placed, or place the results in a different workbook.

Details: On Factory Explorer®'s 'Analyze Output' dialog, you can select the results workbook in which Factory Explorer® will place new output results (worksheets and charts). When it creates an output worksheet or chart in the results workbook, Factory Explorer® usually formats one or more of the data columns. Excel treats the formats that Factory Explorer® uses as custom number formats. If the results workbook already contains 256 built-in and custom number formats, Excel will not be able to complete Factory Explorer®'s format request and will generate a run-time error. The error text depends on the version of Excel: 'Too Many Custom Formats' (Excel 5), 'Cannot Add Any More Custom Formats' (Excel 95), or 'Unable to Set the NumberFormat Property of the Range Class' (Excel 97).

Workaround: Put output results in a different workbook, or remove some custom formats from the results workbook (select Format | Cells | Number in Excel to view formats).

Techalert tafx11-9802


6200 Stoneridge Mall Road • 3rd Floor • Pleasanton, CA 94588 • Tel 925-399-6246 • Fax 925-396-6174
©1995-2015 Wright Williams & Kelly, Inc. • All Rights Reserved • Email: [email protected]