Forum

"Get external data"...
 
Notifications
Clear all

"Get external data" does not have "excel file" option in Excel 2016

2 Posts
1 Users
0 Reactions
198 Views
(@jeansinger)
Posts: 2
New Member
Topic starter
 

I'm just learning Power Query and am trying to practice from the video using Excel 2016. When I go to import a file from Excel, the ribbon does not give me the option to "get external data" from an excel file. Can someone  help explain how to make this work?

Thank you!

Jean

 
Posted : 04/03/2017 3:52 pm
(@jeansinger)
Posts: 2
New Member
Topic starter
 

Never mind... I just figured it out.  The way to import an Excel file is through New Query/From File/From Workbook.

 
Posted : 04/03/2017 4:01 pm
Share: