Mar 07 2019 09:47 AM
Hello,
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?
Regards,
Cesar Ortega
Mar 07 2019 10:15 AM
Hi,
As variant you may activate legacy connectors
and use them from Data->Get Data->Legacy wizards
Mar 07 2019 10:41 AM
When attempting this option I am referred to another error code.
After researching this issue, looks like I have to go under the "save tab" under the same options screen and provide a save location. Once here, it is not letting me type any address in.
Could this be do to not having access?