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.

​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.  Read More

​