Can you give an example of your data, and what your daily update looks like? It's not clear to me if you're editing existing records or simply adding new records to your table.
The ArcGIS Pro documentation discusses excel files in a good amount of detail on this page. Once you have your Excel table added to your map, it will refresh with any updated edits to the spreadsheet when Pro opens. You should be able to continue using Excel to enter your data without much trouble.
- Josh Carlson
Kendall County GIS