Make Cell(s) in Table of Microsoft Excel connect (real-time) to a Page/Section in Microsoft Word (replica of the table)
PART-1 RAW METHOD: Common COPY and PASTE
| PENJUALAN | |
|---|---|
| QUARTER ke-1 | 8.000 |
| QUARTER ke-2 | 7.000 |
| QUARTER ke-3 | 10.000 |
| QUARTER ke-4 | 7.500 |
| TOTAL | 32.500 |
DO NOT UPDATING
PART-2 REAL-TIME UPDATE
Important NOTE! Use Ctrl + Alt + V when PASTE
• AUTO-UPDATING METHOD version 1
Link Excel Cell(s) to Word Table (Real-Time Update)EXCEL TABLE
Keep Word as a Table (not Excel object)
If you want the Word table to remain a real Word table, not an embedded Excel object, then:
▶ You must create individual linked fields per cell.
STEP 1 — Copy a single Excel cell
Example: Copy A1
STEP 2 — In Word
- Go to the table cell
-
Use:
Home → Paste → Paste Special → Paste Link → Unformatted Text
(or press Ctrl + Alt + V, then choose Unformatted Text)
Now the Word cell contains a field like:
{ LINK Excel.Sheet.12 "C:\path\file.xlsx" "Sheet1!R1C1" }
Repeat for each cell you want linked.
💡 This keeps Word’s table format, but pulls live data from Excel.
RESULT (Example)
| PENJUALAN | |
|---|---|
| QUARTER ke-1 | 80.000 |
| QUARTER ke-2 | 70.000 |
| QUARTER ke-3 | 30.000 |
| QUARTER ke-4 | 40.000 |
| TOTAL | 220.000 |
WORD IN PARAGRAPH
RAW:
Total Penjualan tahun ini adalah 32.500
AUTO-UPDATING:
Total Penjualan tahun ini adalah 220.000.
• AUTO-UPDATING METHOD version 2
Replace an entire Word table with linked Excel range (recommended for replicas)
Link Excel Cell(s) to Word Table (Real-Time Update)
This method keeps Excel as the data source. Word shows a replica of the table or cell. When Excel changes → Word updates automatically (or on refresh).
STEP 1 — Prepare the table in Excel
- Select the exact cells you want to appear in Word.
Example: A1:D5 → your table section. - Press Ctrl + C (Copy).
STEP 2 — Go to Word
- Click where you want the table to appear.
-
Go to: Home → Paste → Paste Special...
or press: Ctrl + Alt + V -
In the dialog, choose:
✔ "Paste link", then select:
Microsoft Excel Worksheet Object - Click OK.
RESULT
Word shows a linked Excel table (replica). Any changes in Excel will update in Word (manually refresh if needed).
Comments