Fix the Missing Advanced Option in Excel 2016 From Web
Question details
The user wants to find or restore the Advanced option when importing web data into Excel 2016.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Import web data using the From Web connector and access its advanced options.
- Observed behavior
- A different import window opens, and the Advanced option the user expects is missing.
Identify the web address you want to import and check whether you need advanced settings such as URL parts or HTTP request headers. Menu names and available dialogs can vary by Excel 2016 build and installation.
Open the newer From Web connector
Use the Get Data command to check whether your Excel build offers the Basic and Advanced choices in the newer connector.
In Excel, select Data > Get Data > From Other Sources > From Web. In some builds, look for Data > New Query > From Other Sources > From Web instead.
In the From Web dialog, select Advanced if it is available. Enter the URL parts and any required HTTP request headers, then select OK.
If prompted, select an authentication method. In Navigator, select the table you need and choose Load or Transform Data.
Check and update your Excel 2016 installation
Use this approach if the newer From Web dialog still lacks the Advanced option.
Enable the legacy web import wizard
Use the legacy wizard if you need the older web import workflow rather than the newer connector.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Microsoft Office formats, making it easier to move existing files. It does not restore Excel's missing From Web option.

Frequently Asked Questions
Where is the Advanced option in Excel's From Web connector?
Open Data > Get Data > From Other Sources > From Web and look for Advanced in the dialog. Its availability depends on your Excel edition and build.
How do I enable From Web (Legacy)?
Go to File > Options > Data, select From Web (Legacy) under Show legacy data import wizards, and select OK. Then open it from Data > Get Data > Legacy Wizards.
Will enabling the legacy wizard restore the Advanced option?
Not necessarily. The legacy wizard is a separate import workflow with a different interface; enabling it does not guarantee the newer connector's Advanced settings.
What if Update Options is missing from my Office account page?
Your Office installation may use a different update method or be managed by an administrator. Check with your administrator or the provider of your Office installation.
Can WPS Office fix the missing Excel From Web option?
No. The option is part of Microsoft Excel. WPS Office can open and edit Excel files as an alternative, but Excel-specific queries may not work or refresh in WPS.




