perhaps more details are needed, but have a look at this in the interim
Problem: Unable to Add Layers from ArcGIS Online Using an Enterprise Account in ArcGIS for
a generic error list is available as well
ArcGIS for Excel errors, messages, and warnings—ArcGIS for Excel | Documentation
Thank you, Dan! I got a solution to my problem.