XL: Label Missing from Upper-Left Corner of Consolidation Table (175851)
The information in this article applies to:
- Microsoft Excel for Windows 5.0
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for the Macintosh 5.0
- Microsoft Excel for the Macintosh 5.0a
- Microsoft Excel for Windows NT 5.0
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel 97 for Windows
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q175851 SYMPTOMS
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 9
instead of:
Name Number
Alpha 5
Bravo 7
Charlie 9
CAUSE
This 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.
WORKAROUND
To work around this problem, follow these steps: - Select the consolidation table.
- On the Data menu, click Consolidate.
- Click to clear both the Top Row check box and the Left Column check
box. Then, click OK.
- On the Data menu, click Consolidate. Click to select the Top Row check
box, and then click OK.
- On the Data menu, click Consolidate. Click to select the Left Column
check box, and then click OK.
The label should appear correctly in the upper-left corner of the
consolidation table.
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.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Modification Type: | Minor | Last Reviewed: | 8/18/2005 |
---|
Keywords: | kbprb KB175851 |
---|
|