Embedding an Excel Worksheet into an Excel Worksheet

 Last reviewed: November 3, 1994
Article ID: Q69263
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0

SUMMARY

To embed a Microsoft Excel worksheet into another Microsoft Excel worksheet, do the following:

  1. Start up two sessions of Excel. Because embedding can only take place between applications, you must have both the application that is acting as the embedding server, and the application that is acting as the embedding client, running simultaneously.

  2. Open or create a worksheet in the session that is acting as the server application.

  3. Highlight a range of cells on the worksheet.

  4. Choose Copy from the Edit menu.

  5. Activate the session that is the client application and select a cell in the worksheet onto which you want to place the embedded worksheet.

  6. Press the SHIFT key as you choose the Paste Picture command from the Edit menu.

MORE INFORMATION

The embedded worksheet will appear on the worksheet and, whenever selected, the formula bar will display the following formula 

   =EMBED("ExcelWorksheet",<range_text>)
where <range_text> is a string that describes the range of cells that define the worksheet (in R1C1 notation). For example, while editing the worksheet to be embedded, if you used the CTRL+END keyboard combination to move to and select the active cell at the lower-right corner of the worksheet, and the cell D10 is selected, then the EMBED function would be 

   =EMBED("ExcelWorksheet","R1C1:R10C4")
because R1C1:R10C4 is the R1C1 format for the range of cells, A1:D10, that are active in the worksheet.

An embedded worksheet is used when you want a picture of an existing spreadsheet, but you do not want it to update dynamically.

REFERENCES

"User's Guide 2," version 4.0, pages 142-146 "Microsoft Excel User's Guide," version 3.0, pages 325-327

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 3.0 3.00 4.0 4.00

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: November 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.