Microsoft Office Tutorial – live link to Excel range in Word.

Ashley wants to embed a range of Excel data in a Word document.

If the data in Excel changes (including adding more rows), she wants the Word document to update.

Annoying: If you use Insert, Object in Word, it captures the wrong range and truncates if you add more data.

My method: (1) Set the Print Range in Excel, (2) Select the Print range and Copy. (3) Paste to Word, (4) Open the paste drop-down menu and choose Linked Keep Source Formatting. This reliably works.

How do you solve this? Let me know down in the YouTube comments below.

Table of Contents
(0:00) Problem Statement