Excel Power Query - Change Folder Location (using MS Office Professional Plus 2016 - 64 bit version)

Mark Goodridge1

New Member
Joined
May 19, 2021
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
Hello,

I hope someone can help me with this query:

Each month I run a set of Excel Power Queries to pull data from 50 files into a consolidation model.
Each of the Power Queries pulls through different datasets from the 50 Excel files, e.g. 1 would be for financial data, another would be for HR data, etc.
These are all held in a monthly folder, so P1 would be April, P2 would be May, etc.
Each of the 50 files has the exact same layout in terms of tabs, formula, etc.
Each of the file names has a different description, e.g. File 1 may be called Executive Team 21-22 P2 v1.0.xlsx, File 2 may be called Finance 21-22 P2 v1.0.xlsx, etc.

Yet, each month I find myself having to recreate the Power Query, change the location of the folder, etc. I am using the Data\New Query\From File\From Folder menu options.

At the moment, I transfer 1 file to a holding area within the network, from which I create the Power Query, then once that has been tested and works, I transfer the remaining files and re-run the Power Query.

Obviously, this takes quite a bit of time post-month-end, when we do our monthly financial reporting.

I'm relatively new to Power Queries, but they do save a lot of time, but now I am trying to take it to the next level in order to save even more time, (as per my Manager's request!).

Thank you in advance.

Mark
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,773
Office Version
  1. 365
Platform
  1. Windows
check this video out-->

and this one-->
 
Last edited:
Solution

Mark Goodridge1

New Member
Joined
May 19, 2021
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
Hi

Many thanks for your response. I will have a look at the video, hopefully, it will resolve my issues
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,579
Messages
5,770,969
Members
425,653
Latest member
UNSING

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top