XL97: The Workbook Consolidation Wizard

ID: Q179507

The information in this article applies to:

SUMMARY

This article describes how to download the Workbook Consolidation Wizard, which is an add-in program for Microsoft Excel 97 that you can use to consolidate worksheets from one or more workbooks into a single master workbook.

Currently the only way to perform this task is to use the Move Or Copy Sheet command on the Edit menu, manually copy the sheets and then paste them, or drag the sheets from one workbook to another one. These methods may require a significant amount of time if you want to consolidate many workbooks or worksheets. Using the Workbook Consolidation Wizard is more efficient than using a manual method because the wizard contains options that make consolidating workbooks easier.


MORE INFORMATION

The following file is available for download from the Microsoft Software Library:

Consolid.exe
For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:
Q119591 How to Obtain Microsoft Support Files from Online Services
You can also obtain the Workbook Consolidation Wizard for Microsoft Excel, by using your Web browser to go to the following site:
ftp://ftp.microsoft.com/Softlib/MSLFILES/

Additional query words: Consolidation WCW97EndSheet 


Keywords          : kbtool xlwiz xladdins 
Version           : WINDOWS:97
Platform          : WINDOWS 
Issue type        :

Last Reviewed: June 21, 1999