Home

Show data legacy import wizards help

%3CLINGO-SUB%20id%3D%22lingo-sub-854924%22%20slang%3D%22en-US%22%3EShow%20data%20legacy%20import%20wizards%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854924%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20for%20a%20project%20I%20need%20to%20enable%20legacy%20queries.%20I%20have%20followed%20the%20instructions%20File%26gt%3BOptions%26gt%3BData%2C%20but%20my%20data%20tab%20does%20not%20exist%20there%20but%20rather%20in%20the%20Advanced%20tab.%20Unfortunately%20the%20pane%20to%20enable%20those%20data%20import%20wizards%20does%20not%20seem%20to%20exist%20in%20the%20Data%20section%20under%20Advanced.%20I%20have%20Student%202016%20Excel%20and%20my%20professor%20didn't%20seem%20to%20understand%20my%20problem%20either%20so%20I%20thought%20I%20would%20ask%20here.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEDIT%3A%20I%20will%20attach%20a%20screenshot%20to%20help%20show%20my%20issue.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F131741i0961C55D9D0D83FC%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Screenshot%20(25).png%22%20title%3D%22Screenshot%20(25).png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EThis%20is%20what%20I%20see%20under%20the%20advanced%20tab%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-854924%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857129%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20data%20legacy%20import%20wizards%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857129%22%20slang%3D%22en-US%22%3ECan%20you%20please%20post%20a%20screen-shot%20of%20your%20Excel%20ribbon's%20Data%20tab%3F%20I%20suspect%20you%20already%20have%20the%20legacy%20wizards%20in%20the%20first%20group%20of%20that%20tab.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-857583%22%20slang%3D%22en-US%22%3ERe%3A%20Show%20data%20legacy%20import%20wizards%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-857583%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408648%22%20target%3D%22_blank%22%3E%40Samuelsnow1998%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EData%20section%20under%20Advanced%20was%20long%20ago%2C%20now%20it's%20separate%20Data%20tab.%20Have%20no%20idea%20about%20Student%20version%2C%20perhaps%20it's%20not%20available%20at%20all.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Samuelsnow1998
Occasional Visitor

Hello, for a project I need to enable legacy queries. I have followed the instructions File>Options>Data, but my data tab does not exist there but rather in the Advanced tab. Unfortunately the pane to enable those data import wizards does not seem to exist in the Data section under Advanced. I have Student 2016 Excel and my professor didn't seem to understand my problem either so I thought I would ask here. 

 

EDIT: I will attach a screenshot to help show my issue.Screenshot (25).pngThis is what I see under the advanced tab

2 Replies
Can you please post a screen-shot of your Excel ribbon's Data tab? I suspect you already have the legacy wizards in the first group of that tab.

@Samuelsnow1998 

Data section under Advanced was long ago, now it's separate Data tab. Have no idea about Student version, perhaps it's not available at all.

Related Conversations