Function Problems

How to Pull Data into an Embedded Excel Sheet in Word

Maira Mehtab Sep 21, 2026 869 views

Question details

The user needs to extract a specific value from another worksheet (column G) and display it in cell B3 of an embedded spreadsheet within a Word template.

Product: Word and Excel
Device & OS: not provided
Scenario: Populating an embedded spreadsheet inside a Word document with specific data from a separate source sheet.
Observed behavior: The user is looking for the correct formula syntax to either directly reference a known row or look up a value dynamically using an identifier.

Before you start

Ensure both your source worksheet and the embedded spreadsheet are accessible. Verify the exact name of the source sheet tab, as you will need it to construct your formula correctly.

Solution 1Recommended

Use a Direct Cell Reference for a Known Row

If you already know exactly which row contains the target data in column G, you can use a straightforward cross-sheet reference.

Direct references are the simplest way to pull data across sheets when the data structure is static and the target row will not change over time.

Open the embedded spreadsheet

Double-click the embedded spreadsheet within your Word document to open it in edit mode.

Select the target cell

Click on cell B3 where you want the data to appear.

Enter the reference formula

Type the equals sign (=), then enter the source sheet name followed by an exclamation mark and the target cell address (for example, type =Sheet2!G2).

Confirm the formula

Press Enter. The value from column G in the source sheet will now be displayed in cell B3.

Solution 2

Use XLOOKUP to Find Data Dynamically by an Identifier

When the exact row is unknown or changes frequently, use the XLOOKUP function to search for a unique identifier and pull the corresponding data.

Seamless Office Integration

Use WPS Office to Handle Cross-Sheet Data and Advanced Formulas

WPS Office seamlessly integrates word processing and spreadsheet functionalities, allowing you to easily embed tables, link data, and run advanced formulas like XLOOKUP without switching between heavy applications.

1. Install WPS Office: Download and install the free WPS Office suite on your computer.
2. Open your Word template: Open your document in WPS Writer and double-click the embedded table to activate WPS Spreadsheet seamlessly.
3. Apply the lookup formula: Enter your XLOOKUP or direct reference formula exactly as you would in standard spreadsheet software to pull your data.

Fully supports advanced spreadsheet formulas including XLOOKUP, VLOOKUP, and INDEX/MATCH.Seamless cross-referencing between WPS Writer and WPS Spreadsheet.High compatibility with Microsoft Office file formats (.docx, .xlsx).Lightweight software that loads embedded objects quickly and smoothly.

Frequently Asked Questions

Why does my cross-sheet formula return a #REF! error in the embedded spreadsheet?

This usually happens if the source sheet name is misspelled in your formula, or if the source worksheet has been deleted. Check that the sheet name in your formula (e.g., Sheet2) exactly matches the actual source sheet's tab name.

Can I use VLOOKUP instead of XLOOKUP to find the identifier?

Yes. If your software does not support XLOOKUP, you can use VLOOKUP. For example: =VLOOKUP(identifier, Sheet2!A:G, 7, FALSE). Remember that VLOOKUP requires the search identifier to be located in the very first column of the specified range.

Will the embedded spreadsheet update automatically if the source data changes?

If the source data is located in another tab within the same embedded spreadsheet object, it will update automatically. If the source data is in an entirely separate, external workbook, the embedded spreadsheet will only update if external links are enabled and refreshed.

Excel & Data Problems