Can't expand table

Copper Contributor

I have an xlsx file with multiple tabs.  In one tab is a worksheet with (currently) 14385 rows.  There is a table (Table2) in the worksheet that currently ends at row 14311.  I'd like to expand the table to encompass those rows (and more) but when I Resize the table I get an error reporting that "This operation is attempting to change a filtered range on your worksheet and cannot be completed".  However, I have no filters defined and cannot find anything that could be construed as a filter.  How can I get this table re-sized?


By the way, a Microsoft "tech support" articles says that expanding a table is as simple as typing in a cell in the next row following the end of the table.  Clearly, this doesn't work that way, given my description above.

2 Replies


Could you attach a sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Not possible. However, issue was resolved by clicking on Data in the ribbon, selecting entire contents of current table, clicking the funnel icon to toggle filters off. Although the product is incredibly opaque this worked, although in the process it appears to have self-generated three blank rows immediately following the row that was the bottom in the table before the expansion. Of course it did...