This is because SEQUENCE is a dynamic array function that produces a spilled array, and Excel tables aren't compatible with results generated in this way.

Microsoft Excel: How to Find Missing Numbers in a Sequence. Locating missing sequential numbers can be an arduous task when working with long lists of data. For example, you might want to locate ...

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...