Excel: Size Limit of Input Range in Histogram Tool

 Last reviewed: November 30, 1994
Article 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

KBCategory: kbusage
KBSubcategory:

Additional reference words: 4.00 tool pak pack ATP

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.