Answer
A Microsoft Excel worksheet is exposed by the data source as an OLE DB SYSTEM Table not OLE DB Table. As OLE DB connections in ArcGIS return only Table and View objects, worksheets will not appear when you expand the OLE DB connection to the worksheet.
You must define a named section in the Excel worksheet; this will be exposed as an OLE DB table to ArcGIS.