Advanced option missing from Get data From Web - Excel - MS Office Home and Business Edition 2016

Question

ADVANCE OPTION MISSING FROM GET DATA FROM WEB- MS EXCEL

Once we click on from web option from get external data drop down above screen appears . it doesnt show an option to select 

basic  or advanced.

Version - MS OFFICE HOME AND BUSINESS EDITION 2016

Answer 1

Hi

#1 For forum contributors' eyes could you please change the title of your thread with "Advanced option missing from Get data From Web - Excel - MS Office Home and Business Edition 2016" - Thanks in advance

#2 Is the following dialog box the one you're missing?

if not please explain what you're trying to achieve, in other words what kind of advanced options you need to use for what purpose? And to guide you further - if required - provide the http link you want to query

Answer 2

Hi

(Thank you for our eyes :)

The dialog box you posted appears when you use the Legacy Web import Wizard:

(see How To disable Legacy Wizards via File > Options > Data and look at section Show legacy data import wizards)

Instead you should use Data > Get Data > From Other Sources > From Web:

Answer 3

Hi,

yes, above dialog box is missing.

regards/ts

Answer 4

Hi,

#1 This is the dialogue box that is missing.

#2 This window keeps on popping open whenever I select get data from web.

#3 And here you can see that I am not using Legacy Web Import wizard.

Regards

Diksha Aggarwal

Answer 5

yes.. This Advanced option is missing.. Could you suggest how do i get that?