AutoCAD - Linking to Excel dynamic named range

[wessj03]

I'm on AutoCAD 2020, and I'm trying to create a linked table that uses a named range as it's source. A conventional named range where I simply select cells works fine. However, the named range that I want to use Excel uses the formula below. With this as the source, the named range basically returns results where values in one of my columns = "ROIP-AEP" 

=FILTER(AREA_504!XEZ31:XFB229, AREA_504!XEY31:XEY229 = "RIOP-AEP","Filter Error")

This named range works exactly as it should in Excel.

[The subject line of this post has been edited to include the product name by @handjonathan ]

So when I go to AutoCAD and try to link to this named range

1) I don't see it in the dropdown, instead I see "Sheet1!_FilterDatabase".

2) When I select that one, the table inserts fine, and it sorta works, but the table doesn't return the same results that the named range does in Excel. It returns more rows and columns than it should.

I realize that this is a bit 

[TheCADnoob]

Are you filtering in your range?

Generally the filters are just visual so the data behind them is still the same. So if you filter out 10 rows in excel the data is still actually there and would be carried over despite the state of the filter in excel.