Deleting rows in Excel leaves blank rows in Inventor drawing

[ethan_howardMMXXIV]

Is there a way to delete the blank rows in the drawing? There's a blank row at the end for each row deleted. Thank you.

Autodesk Inventor Professional 2025

64-Bit Edition

Build 162, 2025.0.1 Update - Date: Mon 5/13/2024

Autodesk Vault Professional 2025

Build 30.0.91.0

[ethan_howardMMXXIV]

Here's an example: I deleted one row and now it leaves a blank at the end.

[andrewiv]

Have you considered using a drawing table that is linked to the spreadsheet instead of an OLE object?  Think of the copy/paste from Excel as a screenshot image of the area in Excel that you copied.  In my experience Inventor will always remember the area that you inserted so if you delete a row in Excel you get an empty row on the drawing, but if you add a row ion Excel it won't show up on the drawing.  You will have to delete the object and re-insert it using the new area.  I think if a drawing table is used it will know when changes are made and update accordingly.  It's been a while since I had to do this type of work so the way it behaves could have changed.

[ethan_howardMMXXIV · Accepted solution]

In an Inventor drawing, if you ever need to delete a row in a table created in an embedded Excel, it will leave a blank row at the end of the table.

An embedded Excel table looks like this in the side browser:

You will need to re-insert the table to remove the blank row. Here are the steps.

1. Double-click the table.
2. The table will open in Excel.
3. Highlight the required cells, and right-click copy.
4. You can close Excel because the table is on the clipboard.
5. In inventor, go to the top and click the Manage tab/Insert Object.
6. In the menu, click “Create New” & highlight “MS Excel Worksheet”.
7. A blank Excel worksheet will open.
8. Right-click, “Paste” into cell A1.
9. Format the cells.
10. Close Excel.
11. The table will be on your cursor and can be placed anywhere on the drawing.
12. The table may need to be re-sized.
13. You can delete the table with the blank row.

[ethan_howardMMXXIV]

I appreciate your response. We typically use embedded Excel tables to keep from having to upload a spreadsheet to the Vault.