Forum Discussion
Inserted Excel spreadsheet in Word not updating with added rows
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.
Hi, thanks for your response. What ended up working for me was leaving a lot more blank space in the Word doc where I planned for the table to be before inserting the Excel spreadsheet- adding the blank space after the table has been generated doesn't seem to work.
Now I have the minor problem where, after the table has been generated and I delete a row in the Excel spreadsheet, a blank row remains in the Word table- it's as if it has to maintain the same number of rows as the original table. Once I finalize the data, I can always copy it and insert it as a new Excel spreadsheet (and delete the old one), though this extra step is not ideal.