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.