Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Import Macro Repair

...

Panel
bgColor#fff

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)


Update 2021 – If after enabling this or when opening another file in Excel you do not have the option to choose "Legacy Wizards" (its greyed out) please follow the instructions from Microsoft below:

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_windows8-mso_o365b/i-am-not-able-to-enable-the-text-import-wizard-in/012ec2ad-6dfe-472c-b7e0-cd6a85cb8168

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

...