I am trying to obtain data from case files I have assigned to me through my job's VPN access on web portal. When in excel, I attempt to gather info from Data ribbon using "from web". From here, I am prompted to add URL in which from here I receive an error code once placing.
Details: "The credentials provided for the Web source are invalid. Please update the credentials through a refresh or in the Data Source Settings dialog to continue. (Source)
Is there a way to open an internet tab through excel to obtain data info wanted for manual selection instead of placing URL as prior excel software version did?