Old web query menu

[GorD]

How can i bring up the old excel 2010 web query menu in excel 2016, the one with the wee yellow arroes to select the part of the web page you want. I did it once before with keyboard shortcuts but cant find it again

Many thanks

I think if i use this and log in, PQ is able to access page

 

[sandy666]

you mean Alt+A+FW ?

 

[GorD]

That is what i was trying - but that brings up the new style dialog.

 

[sandy666]

hm, this is the same in 2010/2016
http://www.engineerexcel.com/web-data-import-in-excel-2010/

 

[GorD]

I wonder if it needs a 2003 menu sequence then?

 

[sandy666]

afaik old shortcuts didn't change

but you said you can use PQ so use it

 

[GorD]

can't get it connect - due to log in details required - i got it to work previously by looging in with the old web menu first previously - or thats my therory and memory anyway

 

[sandy666]

maybe:
Access Web Content - Basic
- username
- password

or
https://support.office.com/en-us/ar...er-query-9f24a631-f7eb-4729-88dd-6a4921380ca9

 

[GorD]

So if I use my old laptop which has excel 2010 as well as o365 and I go to the 2010 data from web and fill in my log in details for the webpage, I can then nip back to 365 and update my power query and function. It accesses the site and pulls the data.

My new laptop doesn't have 2010 and i don't particularly want to install it, but cant get my 365 version to be able to access the web site i want

Help appreciated

 

[GorD]

Anyone!!