XL98: Merge Workbooks Not Same as Lotus 1-2-3 "/File (181727)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q181727 SUMMARY
The Merge Workbooks command (on the Tools menu) in Microsoft Excel 98
Macintosh Edition 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 98
Macintosh Edition 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 98 Macintosh Edition. A workbook can be shared between
multiple users. As each user saves a copy of the file, you are 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 add, subtract, or copy the new data to 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.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbualink97 KB181727 |
|---|
|