Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
70
Views
Topic starter
Hello,
I have several excel files, which I have imported and merged using power query excel tool.
It worked great until I added some pivot tables and added sheets into one of my excel files.
The question is how can I direct power query to exclude/ignore specific sheet names?
Any idea?
Thanks
Posted : 19/02/2021 1:24 pm
Hi Zohar,
You need to go back to the step in the query where the sheets and tables are listed and filter out the ones you don't want to include in your query.
Mynda
Posted : 19/02/2021 8:20 pm