This is still an ongoing issue. Of note for ArcGIS Pro 2.4.x and earlier, ESRI recommended 32 bit drivers. With Pro 2.6 and above the driver has to match the bitness of Microsoft Office that you have installed. That being stated, our organization has moved to Office 365 (64 bit) and ArcGIS Pro and ArcMap does not recognized that 'any' version of Office is installed.
newest Microsoft Access Engine 2016 components are available at:
Any ideas on enabling Excel files with ArcGIS Pro 2.6+ with Office 365 would be welcome.