Most people don't take the time to format an excel table to ease the process of bringing it into other software.
This link will help
Work with Microsoft Excel files in ArcGIS Pro—Excel | ArcGIS Desktop
and quit skipping a step by trying to add directly, until you can format the perfect excel file and don't need the helper tool....
Excel To Table—Conversion toolbox | ArcGIS Desktop
A big tip is only have the data you need on one sheet and treat each column as one data type (don't mix data)
Another tip is to ensure that your file names and paths are simple and preferably local.
