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.
WORKAROUND
To 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 the Microsoft products listed at the beginning of this article. 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.
REFERENCESExcel 97For more information about consolidating data, click Contents And Index on the Help menu, click the Index tab in Microsoft Excel Help, type the following text
and then double-click the selected text to go to the "Consolidate Data (Microsoft Excel)" topic. If you are unable to find the information you need, ask the Office Assistant. Excel 5.0"Microsoft Excel User's Guide," version 5.0, pages 528-535 For an overview of consolidating data, click the Search button in Help and type:
Additional query words: 5.00c
Keywords : kbdta xlformula |
Last Reviewed: September 1, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |