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.
2 Replies
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.
