How to import data from sheets in the same Excel workbook as the Power Query query

Опубликовано: 06 Февраль 2025
на канале: Celia Alves - Solve & Excel

28,351

157

Power Query does not offer a connector to import data from an Excel sheet, but we can work around that with this technique.

Note: on a more recent version of Excel, in the Data tab we see a button “From Sheet” under the “Get & Transform Data” group. This button does not allow us to connect to a sheet to inspect and import all the data in it. Instead, this button has the same function as the former button “From Table/Range” and will allow us to import data from a range in a sheet (pre-selected range, table range, named range or the spill range resulting from a dynamic array function.

________________________________________________________
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________

Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer

LIVE CLASSES on YouTube every week: https:www//   / celiaalvessolveexcel

Get access to the Live Classes EXERCISE FILES by joining our Telegram Group at https://t.me/celiaalvessolveexcel

Subscribe to my NEWSLETTER for exciting news about the Excel world: https://bit.ly/learnfromcelia

Solve & Excel Consulting - https://solveandexcel.ca

LinkedIn:   / celiajordaoalves

Facebook:   / solveandexcel

Twitter: @celia_excel

Instagram: @solveandexcel

#excel #msexcel #powerquery #dataanalysis #snapreports #solveandexcel #automation #reportautomation #VBA

#Excel #shorts #solveandexcel #microsoft365 #microsoft #toronto #torontobusiness #wit #msexcel #microsoftexcel #excelreport #excelautomation #snapreports #powerquery #powerquerytraining #powerqueryeditor #worksmarternotharder #canada #msexceltraining #microsoftexceltips