currentpage

Hello world, I have a sheet containing a bunch of PivotTables and graphs. The sheet has an area (B2:F2) where users can input filter criteria which when applied, will automatically filter the graphs displayed to the user. For my data, there are literally tens of thousands of different...

Hi. I have a combo box that the user selects their own name. The linked cell to the combo box is a named range. I was hoping to use that named range to apply a filter based on the name to four pivot tables. I was hoping this would do the trick, with the range set to the CurrentPage filter, but...

I have two PivotFields. One will be a PageField while the other is a RowField. My macro will switch them, while also grabbing values from the top of the page and using these values as the CurrentPage for each Field. I get an error when running the macro that says Error 1004: Unable to Get the...

I have a pivot table with 2 Row Label ([RAMI PN] & [U of M]), 1 Column Label [Date], and one Sum of Value [Weekly Inventory]. I had a slicer set up that would allow the user to filter by [RAMI PN], but 2 of the frequent users have Excel 2007, which doesn't allow slicers. As an alternative...

I have a pivot table with date as a page field. I have the following code which works on the surface, it does change the page field to the most recent date that is stored in cell H7. But the pt does not change - it is not recognizing the date. I tried refreshing again but it changes the date...