Both Excel tables and dynamic array formulas are containers for automatically expanding data. So, if you try to put one thing that automatically expands (such as a dynamic array formula) inside ...

How to Keep Excel From Expanding Cells When Sorting. The Excel software automatically expands rows and columns when you sort data and more room is needed for the extra data.