Home

Website data entry

Highlighted
Cesarortega93
New Contributor

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

2 Replies

Hi,

 

As variant you may activate legacy connectors

image.png

and use them from Data->Get Data->Legacy wizards

When attempting this option I am referred to another error code.

Excel.JPG

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.

offline save.JPG

Could this be do to not having access?

 

Related Conversations
Pulling data from one tab to another
krysphares in Excel on
6 Replies
How can you post response on the website?
ZEERA721 in Microsoft Forms on
0 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies
Maps Data for Scotland
Chris Nicol in Excel on
19 Replies