Is it possible to make dynamic range of Data Table?

[gifariz]

Is it possible to make dynamic range of Data Table? Preferably without VBA.
I have a spreadsheet that can calculate for up to 10,000 rows of Data Table, it takes about 10 seconds to calculate all.
Most of the time, only about 1000 rows is needed so I want to optimize the speed, but sometimes 10,000 is needed.
I couldn't find the Data Table range in Name Manager to make the range dynamic using some of dynamic functions.
I also couldn't find way to resize Data Table range, I had to remove and then redefine the Data Table each time I need to resize.
Thank you in advance.

 

[arthurbr]

Do you mean an Excel Table? It's dynamic by definition

 

[RoryA]

If you mean the =TABLE() function, then I don't think you can since it's the output array you want to be dynamic and that is entirely dependent on where you entered it.

 

[gifariz]

Do you mean an Excel Table? It's dynamic by definition

No, I mean this Data Table from Data ribbon and What-If menu.

If you mean the =TABLE() function, then I don't think you can since it's the output array you want to be dynamic and that is entirely dependent on where you entered it.

Oh I didn't know it is a 'function'. I still don't understand how this special function works, but anyway, so it can't be dynamic. Other features like chart and pivot table can have dynamic reference by defining it in name manager, but I guess not with Data Table. Thank you for answering.

 

[RoryA]

Other features like chart and pivot table can have dynamic reference by defining it in name manager

Yes, but that's the input range, not the output one. With TABLE, your input is just one or two cells.