This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I have a power query which looks into a folder containing multiple workbooks that all have an identical structure.
The query takes a long time to run because it seems to find ALL the data from every sheet before I filter which sheets I actually need data from.
below is the custom column I have which finds the sheet names.
The only sheet I want to extract data from is named "JDE Job Setup" in every workbook.
Is there a way to only find the data in these sheets in order to speed thing up?
any help will be much appreciated.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Hi Matt,
Please see below formula:
Excel.Workbook(
File.Contents([Folder Path] & [Name]), null, true
){[Name ="JDE Job Setup"]}[Data]
Regards
KT