Limitations to Format As Table?

[schatham]

I have an excel spreadsheet (Excel 2010) that has 3 columns, and approximately 59,900 rows. It's been sorted and duplicates (all 3 columns) removed.

I would like to use the Microsoft Fuzzy Lookup tool to match one or more columns to one or more columns in another worksheet. The other worksheet has about 24,000 rows & it could be formatted as a table with no issues.

However, when i try to format the large (59,900) worksheet as a table:

Home -->Format As Table -->Table Style Medium 2

It correctly selects the data range ($A$1:$C$59900), (My table Has Headers = checked), but when I click OK, Excel just sits there. The range stays the same, and the selected cells stay selected, but nothing happens. If I use the shortcut (CTRL-L), it does exactly the same.

I thought the limitation might be 60,000 rows (exact count is 59866), or 64,000 rows. If I split the worksheet in two (approx 30,000 rows in each, it appears to work without an issue. The workbook is not excessively large - approximately 2.5MB with the 2 (59,900 & 24,000) row sheets included.

What is the limit of the number of rows & cells that can be formatted as a table?

 

[schatham]

Never mind!!

I found the issue. There were some blank cells in the table that I had overlooked. Once I filtered those out & copied it to a new sheet, the Format As Table worked fine.