Microsoft Query Error: “This data source contains no visible tables.”

When you import data by using the Microsoft Query Wizard and choose Excel Files as data source, you may receive the following...