XL98: Merge Workbooks Not Same as Lotus 1-2-3 "/File Combine"

Last reviewed: February 25, 1998
Article ID: Q181727
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

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.


Additional query words: XL98
Keywords : xl123quattro kbualink97 kbdta
Version : MACINTOSH:98
Platform : MACINTOSH


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 25, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.