Excel data source is not showing tables even after defining name to excelsheet.


I have exported template from Dynamics 365 for account entity. I want to use that template as my source so I have performed following steps:

  1. Defined name excel by navigating to formula> define name
  2. file type is .xls
  3. created xls connection as source

But when I expand the tables then it is showing me no table