This has been an on-going problem for one of our county departments for quite sometime. They get most of their address data in the form of an Excel (.xlsx) and need to geocode that data. Currently they are using Pro 2.3.1 but this has been a problem in earlier versions as well.
When they try to add an Excel file as a table, they can't:
The one I've highlighted is one I created for them and can add to a Pro session just fine. Here is what it looks like if they use the add data window:
If they copy the data to the local C: drive, they are good to go. These screen shots came from the user having the problem, and I notice she uses unc shares. If I use the unc share instead of a mapped letter drive I can add all the excel spreadsheets I want. To me it seems like a network access issue: Is there something I can ask their Network admin guy to take a look it?