When I click Get Data | Excel | Connect, and then browse to my file, it gives me the option to import my tables and worksheets. The icons are different for tables and worksheets. Is there a benefit to using one over the other, or do you always want to pick one over the other?

Another advantage of tables is that they auto adjust their size to the actual data. If you would add some data somewhere else in your worksheet, it will be imported if you choose worksheet, but if you import from a table, you will only get the data from the table. So you should always use tables, unless your manager disapproves :smileylol:

Difference between importing a table and a worksheet

Forum Discussion

Related content

Importing dynamic named worksheets

Importing excel worksheet among multiple worksheets

Import Entire Worksheet Rather Than UsedRange

Lock worksheet

Need help combining two worksheets