XL: Label Missing from Upper-Left Corner of Consolidation TableLast reviewed: February 5, 1998Article ID: Q175851 |
The information in this article applies to:
SYMPTOMSIn the versions of Microsoft Excel listed at the beginning of this article, if you use the Consolidate command to summarize data from two or more worksheets, the label may be missing from the upper-left corner of the consolidation table. For example, the table may appear as follows
Number Alpha 5 Bravo 7 Charlie 9instead of:
Name Number Alpha 5 Bravo 7 Charlie 9 CAUSEThis problem occurs when you create the consolidation table and you select both the Top Row and Left Column check boxes under "Use labels in" in the Consolidate dialog box.
WORKAROUNDTo work around this problem, follow these steps:
To prevent this problem from occurring when you create a new consolidation table, select only ONE of the two check boxes (Top Row or Left Column) when you create the table. Then, click Consolidate on the Data menu, select the other check box, and then click OK.
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
MORE INFORMATIONThe Consolidate feature in Microsoft Excel allows you summarize data from multiple, identically arranged tables. To see an example that uses the Consolidate feature and demonstrates problem described in the "Symptoms" section in this article, follow these steps:
A1: B1: Number A2: Alpha B2: 5 A3: Bravo B3: 7 A4: Charlie B4: 9Note that the values in the table (5, 7, 9) are the sums of the respective values in cells B2, B3, and B4 in the tables in Sheet1 (1, 2, 3) and Sheet2 (4, 5, 6). Note also that the label "Name" is missing from cell A1. If you follow the steps in the "Workaround" section, the missing label appears correctly, for example:
A1: Name B1: Number A2: Alpha B2: 5 A3: Bravo B3: 7 A4: Charlie B4: 9 |
Additional query words: XL5 XL7 XL97 5.00a 5.00c 7.00a
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |