Jun 08 2024 03:00 PM
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.
Jun 09 2024 03:51 AM
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?
Jun 19 2024 04:13 PM