Excel: Size Limit of Input Range in Histogram Tool

ID: Q92560

The information in this article applies to:

Microsoft Excel for Windows, version 4.0
Microsoft Excel for the Macintosh, version 4.0

SUMMARY

In Microsoft Excel, the Histogram tool (included in the Analysis ToolPak add-in macro) calculates individual and cumulative frequencies for a range of data and data bins. This tool uses an array formula. Because Microsoft Excel 4.0 only allows arrays to contain up to approximately 6550 elements, you may receive incorrect results if you use the Histogram tool with more than 6550 elements. The problem occurs with any array formula, not just with the Histogram tool.

MORE INFORMATION

When you use the Histogram tool and you specify an input range that is larger than 6550 elements you may receive the following error message:

Not Enough memory. Continue without Undo?

In addition, the output range on the worksheet may also contain the #VALUE! error value. If the check box for Chart Output is selected in the Histogram dialog box, you may receive the following error message:

An error has occurred locating a support file or processing data for an add-in procedure.

If you choose the OK button, Microsoft Excel will create a Histogram chart with no bars. This error occurs because in Microsoft Excel versions 3.0 and 4.0 the maximum size limit of for an array is 6550 (equivalent to 64K) elements. Earlier versions of Microsoft Excel have a 16K limit.

Note: The Histogram tool will only be available after you install the Analysis ToolPak add-in macro.

For more information about the Analysis ToolPak see page 195 of the "Microsoft Excel User's Guide 2."

REFERENCES

"User's Guide 2," version 4.0, pages 33-34

"User's Guide 1," version 4.0, page 166

Additional query words: tool pak pack ATP

Keywords :
Version :
Platform :
Issue type :