Excel Pivots Filter - Select All

[mukeshkala]

Hi All,

I have 3 pivots in an Excel File. Below is a sample one .

Bot has to Click on Id Filter(Highlighted) and make it select All instead of (Multiple Items) as shown below.

.

Basically , the data for pivot is in some other sheet, I have to select all the Ids and refresh Pivots.

Build in Uipath Activity - Refresh Pivots only refreshes the Data.

Please Suggest some approaches , Any Hotkeys / Macros .

Do Excel have any formula atleast to open the Filter Menu.

–
Thanks in Advance
Mukesh

[chenderson (Cary Henderson)]

Good morning Mukeshkala,

You should be able to accomplish this task quickly and easily with a small bit of VBA code:

https://www.pivot-table.com/2013/10/30/remove-pivot-table-filters-with-vba/

[mukeshkala]

Thanks a lot

Gave me an context.
Bookmarked page for future reference as well.

Thanks,
Mukesh