Just what I was looking for! So easy to understand. Thank you so much. I keep an month by month tally of my contract work but really wanted to find a way to combine it. This was perfect.
The problem with the way you're doing it is that a) you get four queries you don't actually need and b) new tables in the file aren't included when you refresh the data. It is a much better practice to select the whole file (the folder symbol at 2:50). This will load everything in the file into one query. No need to append anything. Then you can filter what you want which in your case is all tables. If there's a new table it will be automatically included once you refresh your data. Another benefit is that you don't need an extra column with the table name in the original tables. Power Query will import that name. The name is superfluous in the table but very significant in the combined data.
In my use case, both worksheets are in one Excel doc, and I want to include the pivot table in the same Excel doc. When I follow the instructions for pulling the source in Power Query, I get an error that the document is being used by another process. In the video, it looks like you're working in the same Excel doc. Thoughts?
Great video. Thank you. But what if the data in the tables changes, how do you refresh the pivot table. Or do I have to keep loading to power query and then back to excel?
I cant open the file I'm using in power query. I get an error saying Unable to Connect because the file is being used by another process. How am I to pull the sheets?
My only question is when I do data>get data > excel (new /recent) I am getting the power query on a new file. Cant I have it on the same file with my data ? what am I doing wrong ?
Great content! ✨🔥 Your perfect video title called my attention in my Google search. I followed all the instructions and it all worked flawlessly 🙌🏾 The part explaining the relationship was the cherry on top of the cake!!! Thanks heaps from Sydney, Australia 🦘
I have mutiple monthly sheets and I have used xlookup for budget categories. If I convert to a table, I lose the spill, which is not going to help for the query table? What do I do?
Thank you so much for teaching that smoothly. Thanks to you I created a pivot table, amount of 1.7 million row and 20 column data. Made my job way easier. But if I add more data under the table we created, am I gonna get that data to pivot table that I created?
Hello, thanks for the tutorial, while trying to add a new excel source (withing this same workbook) I get the error message: Details: "The process cannot access the file 'C:\Users\miche\OneDrive\Desktop\2024-09-09 Registre - Option 1 (politiques).xlsm' because it is being used by another process." Any idea what to do to fix this?
Very nice video I was looking to combine tables that have different columns; I mean, not the same structure. Some are the same (these I want to use for the pivot table) but there are other ones. Is is possible to combine like this?
What you didn't make clear when selecting the Power Query, you cannot select the same file you already have open. You must be selecting a different file than the one you have open. I get error message file already in use by another process.
Very easy to understand. Great tutorial!
This was so clear and easy to understand. Can't tell you how much time this saved me. Thank you.
Great instruction. Very clear to follow. Thank you
Just what I was looking for! So easy to understand. Thank you so much. I keep an month by month tally of my contract work but really wanted to find a way to combine it. This was perfect.
Thank you very much. Extremely useful.
Thank you, very clear and helpful
The problem with the way you're doing it is that a) you get four queries you don't actually need and b) new tables in the file aren't included when you refresh the data. It is a much better practice to select the whole file (the folder symbol at 2:50). This will load everything in the file into one query. No need to append anything. Then you can filter what you want which in your case is all tables. If there's a new table it will be automatically included once you refresh your data. Another benefit is that you don't need an extra column with the table name in the original tables. Power Query will import that name. The name is superfluous in the table but very significant in the combined data.
You know that you helps thousands People one them its me !.thanks from Dubai
You’re welcome!
@@TeachersTech can you answer the questions below about getting the error file in use?
Thanks - Extremely helpful
Very good 👍
Very good. I'm going to have to watch it a couple of time though. ; )
It was amazing, thanks a lot ❤
Welcome 🙏
Thanks you 😘
In my use case, both worksheets are in one Excel doc, and I want to include the pivot table in the same Excel doc. When I follow the instructions for pulling the source in Power Query, I get an error that the document is being used by another process. In the video, it looks like you're working in the same Excel doc. Thoughts?
Yes exact same issue, great video very well explained, and then get the same error
same error here
Thankyou
Great video. Thank you. But what if the data in the tables changes, how do you refresh the pivot table. Or do I have to keep loading to power query and then back to excel?
I cant open the file I'm using in power query. I get an error saying Unable to Connect because the file is being used by another process. How am I to pull the sheets?
I'm getting this error too and I can't get past it!
I'm getting same error. I need to create a new excel and able load the data, but doesnt make sense to have separate file...
I get the same error
I had the same issue. Close the file with your data, open a blank excel sheet and go through the process. This worked for me.
My only question is when I do data>get data > excel (new /recent) I am getting the power query on a new file. Cant I have it on the same file with my data ? what am I doing wrong ?
Great content! ✨🔥 Your perfect video title called my attention in my Google search. I followed all the instructions and it all worked flawlessly 🙌🏾 The part explaining the relationship was the cherry on top of the cake!!! Thanks heaps from Sydney, Australia 🦘
Teacher before i watch your lesson really u deserve a 100 like thanks a lot for help me to improve myself in our company 🌹🌹🌹🌹
Thank you!
@@TeachersTech Truth be told٫thank you very much for your wonderful effort.May God bless you.🌹
Simple and essay to understand
I have mutiple monthly sheets and I have used xlookup for budget categories. If I convert to a table, I lose the spill, which is not going to help for the query table? What do I do?
I love this!!!
Thank you so much for teaching that smoothly. Thanks to you I created a pivot table, amount of 1.7 million row and 20 column data. Made my job way easier. But if I add more data under the table we created, am I gonna get that data to pivot table that I created?
I wanted to ask this question to
Hello, thanks for the tutorial, while trying to add a new excel source (withing this same workbook) I get the error message: Details: "The process cannot access the file 'C:\Users\miche\OneDrive\Desktop\2024-09-09 Registre - Option 1 (politiques).xlsm' because it is being used by another process." Any idea what to do to fix this?
Hello- This was great, until I got to minute 4.50 and the close and load TO option was not available to me. Need to google how to fix that
Can I do this using an Excel file that's saved to SharePoint? I got stuck at importing the file into the Power Query Editor - couldn't find the file
thanks a lot for this.. :)
I enjoy every single video you drop but I need help creating a questionnaire web app using excel source file
Very nice video
I was looking to combine tables that have different columns; I mean, not the same structure. Some are the same (these I want to use for the pivot table) but there are other ones. Is is possible to combine like this?
@LeilaGharani has a video on this.
@@kakez0 could you address me to it?
What you didn't make clear when selecting the Power Query, you cannot select the same file you already have open. You must be selecting a different file than the one you have open. I get error message file already in use by another process.
thank you
i am not getting pivot table report option under close & load tab
same - did you manage to work it out?