Forum Discussion
Inserted Excel spreadsheet in Word not updating with added rows
Hi,
I have inserted an Excel spreadsheet into my Word document via Insert --> Table --> Excel Spreadsheet. The contents of this spreadsheet show up in my Word document. However, if I insert a new row in Excel, while the row's contents show up and save in the Excel file, they do not appear in the Word document. This seems to be happening particularly if the new rows are added towards the bottom of the table.
I cannot figure out why this is happening and there is plenty of space in the Word document for the new rows to appear. I have tried expanding the size of the table in Word and still no luck.
Any assistance would be appreciated. Thank you.
1 Reply
Below the consideration as workaround:
1. Resize the embedded object frame
o In Word, click once on the embedded Excel table.
o Drag the bottom edge downward to expand the visible area.
o This should reveal the new rows.
2. Double click to edit in place
o Double click the embedded Excel object in Word.
o You’ll enter Excel editing mode inside Word.
o Scroll down the rows are there
3. Use Paste Special → Link
o Instead of embedding, copy the Excel range and in Word use Paste Special → Paste Link → Microsoft Excel Worksheet Object.
o This creates a linked object that updates when the Excel file changes.
o You will still need to resize the frame, but the data stays in sync.
4. Insert as an icon or link to file
o If you want the Word doc to always reflect the full Excel file, insert it as a linked file (Insert → Object → Create from File → Link to File).
o Double clicking opens the full Excel file, avoiding display cutoff issues.
