Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

Problem

After install Office / Excel 365 - The user no longer sees the familiar method for importing webquery report data.  Instead they see the options below.

Solution

The solution involves opening the Excel options and finding and re-enabling the legacy import options. See below.

Click on the "File Menu" and on the bottom left corner you should see the "Options" selection - click this:

  1. You should now be viewing all the options for Microsoft Excel - in particular we want to select "Data" - the third option from the top on the left shown below:
  2. Once you click "Data" - not on the right on the bottom is a list of checkboxes under "Show legacy data import wizards"
  3. Check (at least) the "From Text" legacy import option.
  4. Press the "OK" button.
  5. Open a new workbook.
  6. Navigate to the "Data" menu to active the Data Ribbon options as per normal.
  7. Choose the "Get Data" - the first option on the left hand side.
  8. When the dropdown menu appears - notice there is a Legacy Wizards Option - select that and you should see the option for the old import which proceeds as you'd expect. (Shown below)

https://officesmart.wordpress.com/2018/06/18/turn-on-the-legacy-wizards-in-microsoft-excel-365/

  • No labels