Microsoft KB Archive/68466

First Source Document Determines Consolidation Formatting PSS ID Number: Q68466 Article last modified on 02-26-1993 PSS database name: W_eXceL

3.00

WINDOWS

Summary:

Page 333 of the “Microsoft Excel User’s Guide” incorrectly states that formatting is not consolidated. The consolidated data on the destination sheet will take on the number formatting of the source data from the sheet listed first in the ALL References: box of the Data Consolidation dialog. Existing formatting on the destination sheet will be overwritten.

This documentation error does not occur in Excel version 4.0.

Copyright Microsoft Corporation 1993.