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

Learn Excel’s Sequence function to generate numbers, dates, and custom formats effortlessly. Work smarter and faster with this guide ...

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.