Embedding an Excel Worksheet into an Excel Worksheet

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:

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.

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

Highlight a range of cells on the worksheet.

Choose Copy from the Edit menu.

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

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

Additional query words: 3.0 4.0

Keywords :
Version :
Platform :
Issue type :