IMPORTRANGE with table references?
Can IMPORTRANGE be used to get a table instead of a range? More specifically, can I use column references to only get the columns I want instead of the whole table? I want the imported data to grow as the table grows.
I've tried this:

Where my table name is TCA_IM
And the column is Item ID
I get a #REF! result
Edit:
It works fine if I use a range A2:A2710