Excel: Consolidation Doesn't Display All Categories

 Last reviewed: November 2, 1994
Article ID: Q67464

SUMMARY

After you have run the Microsoft Excel version 3.00 data consolidation feature, if not all of the categories appear in the consolidation report, check for the following:

  1. The range that was highlighted before you chose Consolidate from the Data menu was more than one cell, yet too small to display all of the possible categories. For best results, highlight only the top left cell of the range where the consolidation report is to be placed.

  2. The defined name Consolidation_Area is a range that is too small to contain all the possible categories. For best results, name only the top left cell in the area where the consolidation report is to be placed.

  3. The range or ranges specified in the Data Consolidation dialog box are invalid or incorrect. Verify that the ranges in the dialog box refer to the correct data on the worksheet.

For more information on data consolidation, see pages 325 to 327 of the "Microsoft Excel User's Guide" version 3.0 manual.

KBCategory: kbother
KBSubcategory:



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 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.