ID: Q162313
The information in this article applies to:
The "Merge Workbooks" command (Tools menu) in Microsoft Excel 97 does not provide the same functionality as the "/File Combine" command in Lotus 1-2- 3.
The differences between the "Merge Workbooks" command in Microsoft Excel 97 and the "/File Combine" command in Lotus 1-2-3 are described in the following sections.
The Merge Workbooks menu command is used with the Shared Workbooks feature in Microsoft Excel 97. A workbook can be shared between multiple users. As each user saves a copy of the file, you will be left with multiple copies of the same shared workbook. This feature allows you to merge the copies of the shared workbook into one master file. The copy of the shared workbook that will be used as the master file must be active when you use this feature.
The /File Combine command in Lotus 1-2-3 is used to insert data from a file on a disk to the active cell in your current worksheet. When the data is taken from the file, you can choose to add, subtract, or copy the new data with the data in the current worksheet. You also have the choice to combine the entire file or a named/specified range of the file with the current worksheet.
For more information about Shared Workbooks, click the Office Assistant, type "shared workbooks," click Search, and then click to view the desired topic.
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Excel Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q120802
TITLE : Office: How to Add/Remove a Single Office
Program or Component
Keywords : kbualink97 xl123Quattro
Version : WINDOWS:97
Platform : WINDOWSLast Reviewed: November 5, 1998