Create Excel Pivot Table from Multiple Sheets: The FASTEST Way

[@khanyiphasha1193]

Thank you, very clear and helpful

[@MariaCristiano-t7b]

This was so clear and easy to understand. Can't tell you how much time this saved me. Thank you.

[@donnazimmermann772]

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.

[@davidelphick5793]

Great instruction. Very clear to follow. Thank you

[@brijkathuria1]

Thanks - Extremely helpful

[@muminikar5895]

You know that you helps thousands People one them its me !.thanks from Dubai

[@TeachersTech]

You’re welcome!

[@mjcamm8994]

@@TeachersTech can you answer the questions below about getting the error file in use?

[@denisew2003]

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?

[@mjcamm8994]

Yes exact same issue, great video very well explained, and then get the same error

[@Leibnitz1993]

same error here

[@Meredith-t2m]

Very good. I'm going to have to watch it a couple of time though. ; )

[@ayobamiokediji9604]

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?

[@synn2681]

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?

[@passionateimpulse]

I'm getting this error too and I can't get past it!

[@clairelsh]

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...

[@andrewgeorge4403]

I get the same error

[@marylandcarvajal9909]

It was amazing, thanks a lot ❤

[@TeachersTech]

Welcome 🙏

[@pamella4685]

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 🦘

[@ענתנעמן-מ1ר]

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 ?

[@nelsonacess944]

I love this!!!

[@mustafamustafa-cc2vu]

Teacher before i watch your lesson really u deserve a 100 like thanks a lot for help me to improve myself in our company 🌹🌹🌹🌹

[@TeachersTech]

Thank you!

[@mustafamustafa-cc2vu]

@@TeachersTech Truth be told٫thank you very much for your wonderful effort.May God bless you.🌹

[@LanyoFoster]

Simple and essay to understand

[@furkaneker3605]

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?

[@fifirem724]

I wanted to ask this question to

[@dazjosh746]

I enjoy every single video you drop but I need help creating a questionnaire web app using excel source file

[@flightforge30]

thanks a lot for this.. :)

[@waltergordon4630]

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?

[@MichelLaberge-l7t]

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?

[@erintucker8871]

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

[@davidgruty]

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?

[@kakez0]

@LeilaGharani has a video on this.

[@davidgruty]

@@kakez0 could you address me to it?

[@UrbanCha0s]

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.

[@chasnicole2764]

thank you

[@viniya1958]

i am not getting pivot table report option under close & load tab

[@martinjones9678]

same - did you manage to work it out?