XL97: Merge Workbooks Not Same as Lotus 1-2-3 "/File Combine" (162313)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q162313 SUMMARY
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.
MORE INFORMATION
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.
Merge Workbooks
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.
/File Combine
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.
REFERENCES
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:
120802 Office: How to Add/Remove a Single Office Program or Component
| Modification Type: | Major | Last Reviewed: | 10/22/2000 |
|---|
| Keywords: | kbualink97 KB162313 |
|---|
|