pivot filter

Good day, I have been searching for a solution to applying a filter to multiple pivot tables without using VBA. The scenario is that I would have the user select the filter on a pivot table on Sheet1, and then subsequent sheets would have their filter set to the same value. Is this possible...

Hi All I have an issue where I need to have 5 pivot tables to automatically filterbased on a single cell reference. The cell (K1) is a date that is subject to changedepending on the date the report is required for. The 5 pivot charts all run from the same data table connectionwith slightly...

Hi Just copy the code from online for Pivot table filter base on Cell Reference. Its working fine f no ("blank") in filter. Its blanks its shows Error so i add this Code pf.PivotItems("(blank)").Visible = False Now i getting Run time error 13. Its Date filter base on cell Reference, Any one can...

Hi all, I have what is probably a very basic question, but I cannot seem to find mention of it anywhere here, or even Google. Is there a way to change the format of a pivot table Filter cell so that it is longer than the cells in the same column below in the table. i.e. Can you merge cells...

Hi, My macro displays an image of a product next to the the product's name on the pivot table. It does this by going into an directory where all the products' images are stored. This, however, takes a lengthy amount of time given the number of products. So, I split the directory into many...

Hi, My macro displays an image of a product next to the the product's name on the pivot table. It does this by going into an directory where all the products' images are stored. This, however, takes a lengthy amount of time given the number of products. So, I split the directory into many...

This is my current program: ActiveSheet.PivotTables("Prosthetics").PivotFields( _ "Otto Bock Strategic Business Segment B").CurrentPage = "(All)" With ActiveSheet.PivotTables("Prosthetics").PivotFields( _ "Otto Bock Strategic Business Segment B")...

I need to filter out a pivot table where I don't want to select values starting with 16** Recorded macro code: With ActiveSheet.PivotTables("PivotTable4").PivotFields("OPUS CC") .PivotItems("1650").Visible = False .PivotItems("1651").Visible = False...

Hello, I have created a spreadsheet that identifies subcategories that go beyond x std deviations from the mean. I currently have it set up so that if a cell is selected, the table group name, category, subcategory are found using vba. I would like to then take those values, and filter a pivot...

I am curious if there is a way to copy slicer selections to a sheet so that I can remember what selections where made when I used the spreadsheet. I do not want to copy the entire slicer, just the selections made. Thanks in advance. I am using MS Excel 2010.