The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you use the Consolidate dialog box to consolidate data on worksheets that are contained in the same workbook, if you choose to display the left column labels, and you click the Create Links To Source Data check box, summary labels in the left column display the name of the workbook instead of the sheet name. CAUSE
This behavior occurs because the Consolidate dialog box does not determine
that the consolidated data is contained on worksheets in the same workbook
and that the workbook name does not distinguish where the data is located.
WORKAROUNDTo work around this behavior, on each of the worksheets that you are consolidating, create a local defined name called sheet_title that refers to a cell that contains the worksheet name or the title that you want to appear in the consolidated data. To do this, follow these steps:
STATUSMicrosoft has confirmed this to be a problem in Microsoft Excel 98 Macintosh Edition. MORE INFORMATION
When you use the Consolidate dialog box, the Use Labels In check box allows
you to choose whether to use labels from the top row of the source areas,
from the left column, both, or neither. These check boxes are meaningful
only when you consolidate data by category. Multiple source areas must be
laid out and labeled identically for this option to work accurately. When
you consolidate data by category, be sure to include the category labels in
the source areas you select for your consolidation. Microsoft Excel
transfers these labels to the destination area for you.
Additional query words: XL98
Keywords : kbdta xlformula |
Last Reviewed: January 19, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |