One way to get around this issue is to convert the Excel table to a range by selecting any cell in the table, and clicking ...

If this is wrong, enter (or point) to the correct range; however, if correct, check the box that says My Table Has Headers, then click OK. 5. Excel converts the range into a beautiful color table ...

Click the Data tab and then choose From Table Range in the Get & Transform Data group. If the source data is not in a Table object, Excel will prompt you to convert the data range into a Table object.