Log In
Register
Home
December 17, 2020
Offline
Hi,
I have several .xlsx files stored in a certain path in my computer.
These files have a fixed format, but there are new files will be added later on weekly.
So I do the power query work for each file separately and then combine queries from all files later on.
I saw your video when getting files from a sharepoint folder.
Can I do so with regular .xlsx files from a regular folder?
So the files being added I want it to be added to the work and just refresh the data to get it into results.
Thanks
July 16, 2010
Offline
Hi MG,
Yes, you can do this with Excel files saved on your PC or a network server in the same way. i.e. Get Files > From Folder > browser to your folder path.
Mynda
December 17, 2020
Offline
Thanks a lot and much appreciated.
By the way how to add my picture to my profile?
July 16, 2010
Offline
You're welcome!
You can add a photo by clicking on the 'member' icon above your name. Then edit profile > edit avatar.
Mynda
December 17, 2020
Offline
You can add a photo by clicking on the 'member' icon above your name. Then edit profile > edit avatar.
I did tried but it is not clickable unless I got it wrong.
Did not you mean to click on the icon itself?
It is not clickable.
1 Guest(s)
