- Microsoft Excel For Mac Text Import Wizard Can 27t See All Columns Attached
- Microsoft Excel For Mac Text Import Wizard Can 27t See All Columns Instead
Now in Excel365, we have the Get & Transform area available, which has been described in an older post of mine. The Get & Transform area of the Data tab on the ribbon is superior in terms of DataConnectors and Transformational capabilities. However though, sometimes we just want to use one of the old wizards to import our data such as the LegacyWizards.
The Legacy Wizards do not appear in the Get & Transform area now, they are just hidden waiting for us to turn them on. Below you can find out How To Turn On The Legacy Wizards In Microsoft Excel 365.
We must select the File tab in order to move to Backstage View. Once in BackstageView, from the left of the drop down menu we select the category Options as shown in the image below.
Once we select the Option command, the ExcelOptions dialog box appears, where from the left once more, we select the category Data. Under this category we can ChangeOptionsRelatedToDataImportAndDataAnalysis, as shown below.
At the bottom part of the Data area we notice the area mentioning ShowLegacyDataImportWizards. All we need to do is to activate or deactivate the check boxes at the left of the commands that we need, and which will be displayed in Excel. The commands that are available are the following: