label filters

  1. C

    Find item x in a list VBA

    Hi I want to control a filter in a pivot table with some VBA. The data is a date but displayed in the following format yyyymmdd and is represented as a number. The pivot data looks roughly like <tbody> Date Data 20140201 1 20140201 2 20140201 3 20140202 2 20140202 4 20140202...
  2. T

    Change Label Filter for Every Pivot Table

    I would like to be able to change the label filters for every pivot table in a workbook to the values in specific cell references. The label is a date range between yrmo1 and and yrmo2. I need some sort of VBA looping routine. Basically, I want to just change the cell values once, hit a...
  3. J

    Pivot Tables - Label Filters 'greyed out'

    I constructed a simple pivot table on sperate sheet based on info on another sheet. One problem I ma having is the 'Label Filter' is greyed out. Does this have something to do with the fact that some rows on my data sheet are hidden? As well how can I unhide these hiddne rows, since...
  4. D

    Label Filters, Pivot Tables & Formulas

    I have created a pivot table from cube data in Excel 2007 that shows revenue by company for 2007 and 2008. I have the Year as my columns and wanted to create a label filter using a formula so that it grabs YTD information: i.e. Full Date is between '2007-01-01' and '2007-11-19' However, I...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top