Sometimes, people prefer to use Microsoft Query to extract data from Excel sheets and you encounter this error –
The Fix – Query will recognize only those tables whose range has been named. It will not recognize any range which has been made into Tables. Hence, only named ranges are considered as tables for Query purpose.
1. Hence, you just need to select the range and type the range name in Name Box. Now this range name will appear in Query when you select the workbook.
OR
You can select the cells who you want to be named and right click. Second item from bottom is "Name a Range"
2. If you have already made tables, you can convert the table to ranges. To do this, click a cell in the table and Design menu will get enabled. Press Convert to Range. After this, you will have to execute step 1 to make it Named Range.
