I was looking for a way to have a "Master" slicer without having to add the data to the data model. This is exactly what I was looking for! Such an excellent tutorial and very well explained.
@@AjayKumarparmar I noticed if I select multiple slicer filters, the other slicer won't synchronise. I can see the code only picks up the first selection. Is there a way to adjust the code so it also works when you have multiple selections on the one slicer?
Best tutorial I've seen! I'm a new sub :) Please help with this. Im sure that the coed should work but it doesn't on my end. I think the problem I am facing is due to a missing setting in my workbook or something else? I tried following the video tutorial but my excel does not respond the way it shows in the video. It seems like my macro is not connected to the worksheet I am working on. When I select Run macro it would give me a pop up window asking to select a macro. File type: XLXM VBA> Select Sheet9> View Code> Select Workbook> Select PivotTableUpdate
if you running a macro from vba editor then your cursor should be inside your code which you are trying to run. Pop up comes and ask you for a macor to run when cursor is outside the sub and end sub. vba does not know which macro to fire so it gives that pop up.
@@AjayKumarparmar Thanks for pointing that out. :) Also, I read somewhere that something I did could have stopped my worksheet code to automatically run. When I tried Crtl + G and typed in " ? Application.UpdateEvents" and it returns False. I switch it to True and the program runs smoothly. :) Probably that happened when I accidentally deleted one slicer or due to multiple codes I tried prior to the codes in your tutorial. Power pivot data model didn't work for me too since it removes the number formatting which is very important for my project. It's been 3 exhausting days, glad and so thankful for your tutorial. And you even explain how each code works which helps me understand better than just copy-paste the codes. 👍
@@annex9290 you can write application events= true in module and run it manually if ever happen again. What you said is also correct. Control g opens immediate windows and that is also ok
Very good Sir! Very Well explained . Thank you for the details. I used the exact definition of the different objects but when I ran the for loop to check the different item in the slicer I got the following error message: Run-time error ‘1004’ Application-defined or object-defined error. Any idea of bow I can fix this error message?
Thank you Sir for your quick reply! I did check the slicers name several times and they are corrected. I used the sheets where the pivots are located. Maybe it is a setting causing the error message?
Hello, it is a pleasure to see this type of content, a question, do you have a video in which each item of a slicer can be whistled in a different color, for example? I have a "category" slicer and has the following items 1. warehouse 2. store 3. purchases then in the slicer on the slicer button store this red color on the store slicer button this is yellow on the slicer button you buy this one green is it possible to do that?
Hi, thanks for this video. Its what i search since days, but more : If the 1st slicer has multiple selection, how to get the values in the 2nd slicer ?
@@AjayKumarparmar Hi. yes, in your first slice_region, if you have 2 or more regions selected, how do a loop to pass the multiple regions in the slicer region_1? ==> the slicer_region_1 has several items selected at the end. And i confirm as Joris that the treatment takes a long time (we see it's one by one...) I have more than 20 items in the 2nd slicer... 🙂
GM, AP. Nicely explained, however I have 2 queries 1. Seek a code with 3 slicer, as I have a 3 (table)dependent slicers, my goal is to update the data Grand totals linked to Output Range formula at each sub slicer item selection, as well update the PT from different dataset and below that Generate the graph from PT from Selected item from the 3rd slicer. At the end once all update the full report range should save it as pdf with the active slicer item as a name to the pdf file. Actively i could run this with 3 macro buttons click. I seek help to slicer combination by clicking or running the combined code with the last visible slicer item selection or with a auto loop on visible item. Thanks in advance. 👍
Hi, I noticed this macro takes a long time to run (about 10-15 seconds on a fairly high end laptop). The two slicers only contain 7 items and there 1 pivot table updating. Any chance to make this run faster?
Hi Sir thanks for the reply...In ur above VBA code if we I want to select more than one slicer like example I want to select Delhi and Mumbai together the same way other slicer also should reflect...
I was looking for a way to have a "Master" slicer without having to add the data to the data model. This is exactly what I was looking for! Such an excellent tutorial and very well explained.
Glad it helped!
@@AjayKumarparmar I noticed if I select multiple slicer filters, the other slicer won't synchronise. I can see the code only picks up the first selection. Is there a way to adjust the code so it also works when you have multiple selections on the one slicer?
This helped me solve a very perplexing problem. Thank you!
Happy for you David
Very nice explanation and wonderful teaching style 👌
Thank you for your excellent feedback
Happy and Healthy New Year Guru ji, Wonderful Explanation as usual....
Happy new year
Best tutorial I've seen! I'm a new sub :)
Please help with this. Im sure that the coed should work but it doesn't on my end. I think the problem I am facing is due to a missing setting in my workbook or something else? I tried following the video tutorial but my excel does not respond the way it shows in the video. It seems like my macro is not connected to the worksheet I am working on. When I select Run macro it would give me a pop up window asking to select a macro.
File type: XLXM
VBA> Select Sheet9> View Code> Select Workbook> Select PivotTableUpdate
if you running a macro from vba editor then your cursor should be inside your code which you are trying to run. Pop up comes and ask you for a macor to run when cursor is outside the sub and end sub. vba does not know which macro to fire so it gives that pop up.
@@AjayKumarparmar Thanks for pointing that out. :)
Also, I read somewhere that something I did could have stopped my worksheet code to automatically run. When I tried Crtl + G and typed in " ? Application.UpdateEvents" and it returns False. I switch it to True and the program runs smoothly. :) Probably that happened when I accidentally deleted one slicer or due to multiple codes I tried prior to the codes in your tutorial.
Power pivot data model didn't work for me too since it removes the number formatting which is very important for my project. It's been 3 exhausting days, glad and so thankful for your tutorial. And you even explain how each code works which helps me understand better than just copy-paste the codes. 👍
@@annex9290 you can write application events= true in module and run it manually if ever happen again. What you said is also correct. Control g opens immediate windows and that is also ok
Very good Sir! Very Well explained . Thank you for the details. I used the exact definition of the different objects but when I ran the for loop to check the different item in the slicer I got the following error message: Run-time error ‘1004’ Application-defined or object-defined error. Any idea of bow I can fix this error message?
May be slicer names have a problem in code. Or reference you are giving to worksheets where pivots are located
Thank you Sir for your quick reply! I did check the slicers name several times and they are corrected. I used the sheets where the pivots are located. Maybe it is a setting causing the error message?
Hello, it is a pleasure to see this type of content, a question, do you have a video in which each item of a slicer can be whistled in a different color, for example?
I have a "category" slicer
and has the following items
1. warehouse
2. store
3. purchases
then in the slicer
on the slicer button store this red color
on the store slicer button this is yellow
on the slicer button you buy this one green
is it possible to do that?
To my best knowledge you can not color every slicer differently
@@AjayKumarparmar Thanks for your kind reply. I will continue watching your content..
Hi, thanks for this video. Its what i search since days, but more : If the 1st slicer has multiple selection, how to get the values in the 2nd slicer ?
Can you elaborate please
@@AjayKumarparmar Hi. yes,
in your first slice_region, if you have 2 or more regions selected, how do a loop to pass the multiple regions in the slicer region_1? ==> the slicer_region_1 has several items selected at the end.
And i confirm as Joris that the treatment takes a long time (we see it's one by one...)
I have more than 20 items in the 2nd slicer... 🙂
Great sir your every video uniq and helpfull
GM, AP. Nicely explained, however I have 2 queries 1. Seek a code with 3 slicer, as I have a 3 (table)dependent slicers, my goal is to update the data Grand totals linked to Output Range formula at each sub slicer item selection, as well update the PT from different dataset and below that Generate the graph from PT from Selected item from the 3rd slicer. At the end once all update the full report range should save it as pdf with the active slicer item as a name to the pdf file. Actively i could run this with 3 macro buttons click. I seek help to slicer combination by clicking or running the combined code with the last visible slicer item selection or with a auto loop on visible item. Thanks in advance. 👍
Such thing's need to be learn Rajendra. It's not so easy. Check www.ajayparmartutor.com
Awesome
Thanks Sir
Thank you
Hi, I noticed this macro takes a long time to run (about 10-15 seconds on a fairly high end laptop). The two slicers only contain 7 items and there 1 pivot table updating. Any chance to make this run faster?
No it cannot take so much time. Must be something else bothering machine
Hi, how can we connect multiple selections in slicers ?
Collection loop slicers
I need to select group of slicers, how to add that code in this macro
I didn't understand
Hi Sir thanks for the reply...In ur above VBA code if we I want to select more than one slicer like example I want to select Delhi and Mumbai together the same way other slicer also should reflect...
how to link data from 10 to 15 worksheets ?
Collection Loop
Sir ap na python series q rok di hai?
U want it?
@@AjayKumarparmar Yes Sir
@@muhammadfaizan2637 it's coming today in Fri special episode. I request you to bring more and more students here. 200 subscriber i need from you. ❤️
@@AjayKumarparmar m zaror class lnga and group m bhi apka channel shear kr data ho taka or Students Knowledge la saka
@@muhammadfaizan2637 thank you very much
Happy and Healthy New Year Guru ji, Wonderful Explanation as usual....
Happy new year