Last seen: Dec 22, 2025
Hi Joe, Have you applied all the tricks in the book to reduce all possible error sources, as described here: Try changing the order of the fields...
If the data is sorted after the Month Number, the Month Name slicer will be sorted in the same order. Can you upload a screenshot to show us what i...
Hi Khurram, in Data section, In the Modeling tab, you can sort the column you want. The best way is to have a Month Name column and a Month Number,...
Here it is again. Basically, instead of sending the active sheet only, I added a new procedure that will loop through all sheets, activate the shee...
bcwilk said When I tested the code I received this error: Run-time error '457: This key is already associated with an element of this collectio...
Hi Sunny, That's a different case, the code is designed to restore the slicers to the exact situation they were before disconnecting. For example, ...
You can remove that line pt(i).SaveData = True from code, it's irrelevant to your situation. If you're using the version with connect and reconnect...
Hi, That is a weird error. It means that one of your slicers is connected more than once with the same pivot table, which I don't think it's possib...
I did tested it, and I tested again on a new file, works on my side (excel 2016). Tested again in the attached sample file, this time I split the c...
Hi, I wrote once a code for a similar task, you're lucky 🙂 You will have to test the code and adjust it to your needs though: Sub Disconnect...
Hi Hooi, Another option is to use Quarters. Use a formula like this one to create quarters from a date column: =INDEX({"Quarter 1","Quarter 2","...
Can you tell us why are you disconnecting slicers?
Try this version, it will send an email for each sheet, the PDF files will be saved in the same folder where this tool is saved (in a new folder named...
Hi Wills, A sample file was a better option. I'm attaching a sample file, most probably it will not match your design, so you will still have to wo...
Hi Frans, I think you want the "Full" INDEX function, to detect the row where the match is found, but also the column of the table where to take da...