I am inserting an existing excel spreadsheet into my drawing via the "insert objects" dialog box.

the table inserts as shown here:

so far so good.

now, I want to resize the table so that all the empty cells aren't showing:

this is gravy, as all you have to do is double click the table, resize the visible window, and it reflects back to the drawing.

The problem I'm having is, I want my table to be "linked" to the existing excel spreadsheet so that it reflects changes made to the excel spreadsheet on the drawing.

With my "linked" table, if i double click it to try and resize it, it opens the table in excel for editing.

so how do i get rid of all the empty cells on my "linked" inserted excel spread sheet??

table on the left is not linked, i can adjust the "visible area" just fine.

cant figure out how to do it on the right, linked, table.